public int Update(ProjectSaleQuotation projectSaleQuotation) { UpdateCommand.Parameters["@ID"].Value = projectSaleQuotation.ID; UpdateCommand.Parameters["@ReferenceNo"].Value = projectSaleQuotation.ReferenceNo; UpdateCommand.Parameters["@ProjectID"].Value = projectSaleQuotation.ProjectID; UpdateCommand.Parameters["@ProjectName"].Value = projectSaleQuotation.ProjectName; UpdateCommand.Parameters["@CustomerName"].Value = projectSaleQuotation.CustomerName; UpdateCommand.Parameters["@Total"].Value = projectSaleQuotation.Total; UpdateCommand.Parameters["@Discount"].Value = projectSaleQuotation.Discount; UpdateCommand.Parameters["@NetTotal"].Value = projectSaleQuotation.NetTotal; UpdateCommand.Parameters["@CreatedDate"].Value = projectSaleQuotation.CreatedDate; UpdateCommand.Parameters["@Username"].Value = projectSaleQuotation.Username; UpdateCommand.Parameters["@Status"].Value = projectSaleQuotation.Status; int returnValue = -1; try { UpdateCommand.Connection.Open(); returnValue = UpdateCommand.ExecuteNonQuery(); } catch (SqlException ex) { Logger.Write(ex); } finally { UpdateCommand.Connection.Close(); } return(returnValue); }
private ProjectSaleQuotation DataTableToEntity(DataTable dt) { ProjectSaleQuotation projectSaleQuotation = new ProjectSaleQuotation(); if (Null.IsNotNull(dt) == true && dt.Rows.Count > 0) { if (Null.IsNotNull(dt.Rows[0])) { DataRow dr = dt.Rows[0]; if (Null.IsNotNull(dr["ID"])) { projectSaleQuotation.ID = Convert.ToInt32(dr["ID"]); } else { projectSaleQuotation.ID = 0; } if (Null.IsNotNull(dr["ReferenceNo"])) { projectSaleQuotation.ReferenceNo = Convert.ToString(dr["ReferenceNo"]); } else { projectSaleQuotation.ReferenceNo = string.Empty; } if (Null.IsNotNull(dr["ProjectID"])) { projectSaleQuotation.ProjectID = Convert.ToInt32(dr["ProjectID"]); } else { projectSaleQuotation.ProjectID = 0; } if (Null.IsNotNull(dr["ProjectName"])) { projectSaleQuotation.ProjectName = Convert.ToString(dr["ProjectName"]); } else { projectSaleQuotation.ProjectName = string.Empty; } if (Null.IsNotNull(dr["CustomerName"])) { projectSaleQuotation.CustomerName = Convert.ToString(dr["CustomerName"]); } else { projectSaleQuotation.CustomerName = string.Empty; } if (Null.IsNotNull(dr["Total"])) { projectSaleQuotation.Total = Convert.ToDecimal(dr["Total"]); } else { projectSaleQuotation.Total = 0.00m; } if (Null.IsNotNull(dr["Discount"])) { projectSaleQuotation.Discount = Convert.ToDecimal(dr["Discount"]); } else { projectSaleQuotation.Discount = 0.00m; } if (Null.IsNotNull(dr["NetTotal"])) { projectSaleQuotation.NetTotal = Convert.ToDecimal(dr["NetTotal"]); } else { projectSaleQuotation.NetTotal = 0.00m; } if (Null.IsNotNull(dr["CreatedDate"])) { projectSaleQuotation.CreatedDate = Convert.ToDateTime(dr["CreatedDate"]); } else { projectSaleQuotation.CreatedDate = DateTime.Now; } if (Null.IsNotNull(dr["Username"])) { projectSaleQuotation.Username = Convert.ToString(dr["Username"]); } else { projectSaleQuotation.Username = string.Empty; } if (Null.IsNotNull(dr["Status"])) { projectSaleQuotation.Status = Convert.ToString(dr["Status"]); } else { projectSaleQuotation.Status = string.Empty; } } } return(projectSaleQuotation); }