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);
}
