public int EditRouteTrx(RouteTrx objRouteTrx)
{
try
{
sqlListParam = new List <SqlParameter>();
sqlListParam.Add(new SqlParameter("@RouteTrxID", objRouteTrx.RouteTrxID));
sqlListParam.Add(new SqlParameter("@RowStatus", objRouteTrx.RowStatus));
sqlListParam.Add(new SqlParameter("@CreatedBy", objRouteTrx.CreatedBy));
DataAccess dataAccess = new DataAccess(Global.AllVisionsCS);
int intResult = dataAccess.ProcessData(sqlListParam, "spRouteTrxEdit");
strError = dataAccess.Error;
return(intResult);
}
catch (Exception ex)
{
strError = ex.Message;
return(-1);
}
}
public RouteTrx GenerateRouteTrxObject(SqlDataReader sqlDataReader)
{
objRouteTrx = new RouteTrx();
objRouteTrx.RouteTrxID = Convert.ToInt32(sqlDataReader["RouteTrxID"]);
objRouteTrx.RowStatus = (short)sqlDataReader["RowStatus"];
objRouteTrx.CreatedBy = sqlDataReader["CreatedBy"].ToString();
if (sqlDataReader["CreatedTime"] != null && sqlDataReader["CreatedTime"].ToString() != "")
{
objRouteTrx.CreatedTime = Convert.ToDateTime(sqlDataReader["CreatedTime"]);
}
objRouteTrx.LastModifiedBy = sqlDataReader["LastModifiedBy"].ToString();
if (sqlDataReader["LastModifiedTime"] != null && sqlDataReader["LastModifiedTime"].ToString() != "")
{
objRouteTrx.LastModifiedTime = Convert.ToDateTime(sqlDataReader["LastModifiedTime"]);
}
return(objRouteTrx);
}
