Comments by Onur ERYILMAZ

Onur ERYILMAZ 7-Feb-18 1:35am View

I check that and I found out that the problem is my Date properties, if I send my json like this;

{"WorkCommandNumber":"F999/1","BLPProductCode":"F999","ReceivedOrderNumber":16,"GroupNumber":1}

The object's properties perfectly setting, but when I add the Date like this;

{"WorkCommandNumber":"F999/1","BLPProductCode":"F999","ReceivedOrderNumber":16,"GroupNumber":1,"WorkCommandOpenDate":"2017-12-04T23:00:00+02:00"}

I get bad request error.

How to solve that?

Onur ERYILMAZ 4-Feb-18 10:36am View

Thank you for reply.

As I understand, you recommend starting from scratch with using WPF or Xamarin Forms. I will consider that.

I have a few questions though.

1- You talked about domain objects and business objects. As I understand I need to seperate my objects.

For example:

EF creates an object based on my database schema like this;

public class Company
    {
        [Required]
        [Key]
        public string CompanyCode { get; set; }
        public string CompanyName { get; set; }
        public CompanyTypes CompanyType { get; set; }
        public string CompanyTaxAdministration { get; set; }
        public string CompanyTaxNumber { get; set; }
        public string CompanyWebAdress { get; set; }
        public string CompanyMailAdress { get; set; }
        public byte[] CompanyLogo { get; set; }

        public virtual ICollection<CompanyAddress> CompanyAddresses { get; set; }

        public Company()
        {
            CompanyAddresses = new HashSet<CompanyAddress>();
        }
    }

And I have an object like this:

public class Company
    {
        public string CompanyCode { get; set; }
        public string CompanyName { get; set; }
        public CompanyTypes CompanyType { get; et; }
        public string CompanyTaxAdministration { get; set; }
        public string CompanyTaxNumber { get; set; }
        public string CompanyWebAdress { get; set; }
        public string CompanyMailAdress { get; set; }
        public byte[] CompanyLogo { get; set; }

        public Company(string cCode, string cName, CompanyTypes cType, string taxAdmin, string cTaxNum, string web, string mail, byte[] logo)
        {
            CompanyCode = cCode;
            CompanyName = cName;
            CompanyType = cType;
            CompanyTaxAdministration = taxAdmin;
            CompanyTaxNumber = cTaxNum;
            CompanyWebAdress = web;
            CompanyMailAdress = mail;
            CompanyLogo = logo;
        }
    }

So, when user wants to create a new company, first I get the user inputs and put these in my Company object and then convert this object to EF object with AutoMapper then send EF object to repository to save it?

Onur ERYILMAZ 24-Jan-18 9:20am View

Exception thrown: 'AutoMapper.AutoMapperConfigurationException' in AutoMapper.dll
Exception thrown: 'AutoMapper.AutoMapperConfigurationException' in System.ServiceModel.dll
Exception thrown: 'AutoMapper.AutoMapperConfigurationException' in System.ServiceModel.dll

I can also post my all models and modeldto's?

Onur ERYILMAZ 24-Jan-18 8:47am View

Unfortunately this is not working either :(

Onur ERYILMAZ 24-Jan-18 7:53am View

Thank you for your response.

Class WorkCommands is exists but I don't want to transfer this class, I only want to transfer ID, WorkCommandNumber, WorkCommandDocumentDefinition, WorkCommandDocument and FileExtension properties.

Onur ERYILMAZ 28-Dec-17 1:27am View

Thank you for reply.
No, this codes works fine.
What I want to know that how to properly use this.
Can I use this repository directly with unit of work;
Like;
UnitOfWork work = new UnitOfWork(new BILPLASDatabaseContext());
var products = work.Repository<workcommandproductions>().GetAll();

or am I need to write generic Controller class with singleton design pattern.

Onur ERYILMAZ 26-Dec-17 6:21am View

Yes, it doesn't get entites from database.

Onur ERYILMAZ 24-Nov-17 1:02am View

Yes my table have a primary key, and my DataGridView have a column with this primary key's name.

Onur ERYILMAZ 23-Nov-17 1:41am View

Thank you for reply. I know what read only is, my question is why it is not work in this case.(I mean I setted the row's read only true but users still can edit rows.)

Onur ERYILMAZ 7-Nov-17 16:15pm View

Firstly, thank you for your response.

I want to do this;
Update dbo.Stock SET dbo.Stock.Quantity += dbo.OutgoingStockProducts.Quantity WHERE dbo.Stock.StockCode = dbo.OutgoingStockProducts.StockCode
every product in OutgoingStockProducts that match the 'FormID'.

Further example;
Assume that "SELECT * FROM dbo.OutgoingStockProducts WHERE FormID = 5"
returns 3 rows.
All I want to do is increase the dbo.Stock.Quantity for these items according to the dbo.OutgoingStockProducts.Quantity.

I examine your query and I think the query below might work?

UPDATE dbo.Stock
SET dbo.Stock.Quantity += dbo.OutgoingStockProducts.Quantity
FROM dbo.OutgoingStockProducts
INNER JOIN inserted ON dbo.OutgoingStockProducts.FormID = inserted.FormID
INNER JOIN dbo.Stock ON dbo.OutgoingStockProducts.StockCode = dbo.Stock.StockCode

Thank you again.

Onur ERYILMAZ 12-Oct-17 6:12am View

I have already cascade at delete option on. My problem is getting a column value from Table1 on deleting.

Onur ERYILMAZ 4-Oct-17 6:08am View

But my Form has only one GridView.

Onur ERYILMAZ 4-Oct-17 4:10am View

Ok, I implemented it to my project but unfortunately another problem occurs.
Let's say I have a data table in my database that stores ID, Name and Surname informations of people, and I have another table that stores ID and PhoneNumber of people.
In my ListViewTypes enum, I have enum's like this Persons and PersonsWithPhoneNumbers.
So, PersonsHandler class can handle retrieving data from only one data table but when I need Person's with Phone Numbers then I have to create another class PersonHandlerWithPhoneNumbers. Which is meaningles I thing.

I can add another method like PopulateGridViewWithExtraInformation to the IDataHandler. But in this case I have to add this method to all Handlers, and this is meaningless either.

What would you suggest to handle this kind of situations?

Thank you.

Onur ERYILMAZ 3-Oct-17 11:15am View

I will implement it tomorrow and I will share my code for check if I do this right. Thank you.

Onur ERYILMAZ 21-Sep-17 5:12am View

Thank you for your answer OriginalGriff.

I have managed to connect by using Username and Password like you said. I can continue with that.

But I can't figured it out why I can't connect the database via Windows Authentication. I mean I am I missing?

Onur ERYILMAZ 20-Sep-17 12:36pm View

sqlconnection opening error.

Onur ERYILMAZ 7-Sep-17 7:09am View

You gave me nothing ;)

Onur ERYILMAZ 7-Sep-17 6:22am View

I don't want a null string eighter.

Onur ERYILMAZ 7-Sep-17 6:11am View

Bu the problem is I don't want to write "Small", I want this =IF(B7>15, "Big", otherwise leave the cell unthouched)

Onur ERYILMAZ 7-Sep-17 5:51am View

Because If function always sets the cell 'False' or 'Empty', what I wanted to do if the condition is not match, do nothing. So built in if function does not offer otherwise do nothing option.

Onur ERYILMAZ 8-Apr-14 11:13am View

Deleted

Thank you for your answer. But i still don't understand XML files :( I look some guides or web sites , but i don't understand.

<pre lang="xml"><question>
<number>1

<options>
<option>
<number>1
<optionText>option 1 text</optionText>
<option>

<option>
<optionNumber>n</optionNumber>
<optionText>option n text</optionText>
<option>
</options>


<responses>
<response>1

</pre>

Is this XML code for only one question?
What is the Options and Option blocks?

Can you organize your XML code to my code(only one question) please? It helps me a lot...

On the other hand, i don't understand some parts of your codes, which are;

<pre lang="c#">while (unanswered.Count > 0) {
int qNo = (new Random()).Next(unanswered.Count+1));
question = unanswered(qNo);
unanswered.RemoveAt(qNo);
answered.Add(question);
// Display question and prompt user to respond.
getUserResponse(question);
}</pre>

In this code,is "getUserResponse" is a separate function,if it is what is inside this function?

<pre lang="c#"> List<question> unanswered = new List<question>();
List<question> answered = new List<question>>();

// Assume document is loaded and we have the root node.
// Get the full list of question nodes.
XmlNodeList nodelist = root.SelectNodes(myQuestionPath);

// Load the questions
foreach (XmlNode n in nodelist) {
unanswered.Add(new question(n));
}</pre>

In this code, you wrote "// Assume document is loaded and we have the root node.// Get the full list of question nodes." , in this section of code i wrote this code ,is this code right?

<pre lang="c#">
XmlTextReader xmlrd = new XmlTextReader(@"C:\\Users\Onur\Desktop\xml deneme.xml");

XmlDocument doc = new XmlDocument();
doc.Load(xmlrd);

XmlNode root = doc.SelectSingleNode("question");
XmlNodeList list = root.SelectNodes("options");</pre>

In this code ,first you wrote Number but you never used it, what is it?
Second, you created 3 lists which are "Options","Responses" and " Answers" , but i can't figure how to implement this lists using my XML file.

<pre lang="c#"> class question {
public question(XmlNode q) {/*load question from XML node*/}
public Number {get; set;}

// List of options to choose from.
public List<option> Options {get; set;}

// List of valid responses
public List<response> Responses {get; set;}

// User answers
public List<answer> Answers {get; set;}
}</pre>

Thank you again...

Onur ERYILMAZ 20-Jul-13 17:25pm View

I want to something like this site;
http://en.wikipedia.org/wiki/Main_Page
As you see you click items on the left area , item content is appears middle of the page...

Onur ERYILMAZ 20-Jul-13 16:54pm View

Thanks to answering my question , but i not want to add URL my linkbutton actually :)
If user click my datalist item(which is any food name) , this item's information apperars on the middle of my web page...

protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName == "CommentArea")
{

}
}

So , what can i write in my item click event to do this...

Onur ERYILMAZ 11-Jul-13 13:14pm View

i get an error in connection1.sqlcommand.CommandText = query;

Onur ERYILMAZ 11-Jul-13 10:26am View

Object reference not set to an instance of an object error

Onur ERYILMAZ 10-Jul-13 17:24pm View

i reach DbConnection but i get error message again :(

Onur ERYILMAZ 10-Jul-13 17:12pm View

Yes i saw this now , when i debug but i cant reach DbConnection method... Normally i can use this in my Businesslayer , goodob.sqlconnectionlayer.class1.DbConnection bu unfortunately i can't reach...

Onur ERYILMAZ 10-Jul-13 17:07pm View

I debug my code putting breakpoints and i saw my connection1 and my query is return null , is this my problem or what can i do?

Onur ERYILMAZ 10-Jul-13 16:59pm View

And i forgot to write an error message...

Here : Object reference not set to an instance of an object.

Onur ERYILMAZ 10-Jul-13 16:56pm View

Thank you again...

Onur ERYILMAZ 10-Jul-13 16:56pm View

Thamk you for your comment...

Onur ERYILMAZ 10-Jul-13 16:55pm View

Thank you for your solution...

Onur ERYILMAZ 10-Jul-13 16:55pm View

public class Class1
{
public System.Data.SqlClient.SqlConnection connection;
public System.Data.SqlClient.SqlCommand sqlcommand;

public void DbConnection(){
string connectionSql = "Server=ONUR\\SQLEXPRESS;Database=goodorbad;Trusted_Connection=True;";

connection = new SqlConnection(connectionSql);

sqlcommand = new SqlCommand();

sqlcommand.Connection = connection;
connection.Open();
}
public void close_connection(){
connection.Close();
}

}

this is my connection class is there wrong statement in here ... Thank you for comment btw ;)

Comments by Onur ERYILMAZ (Top 33 by date)