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