public int EditRouteTemplateLine(RouteTemplateLine objRouteTemplateLine)
{
try
{
sqlListParam = new List <SqlParameter>();
sqlListParam.Add(new SqlParameter("@RouteTemplateLineID", objRouteTemplateLine.RouteTemplateLineID));
sqlListParam.Add(new SqlParameter("@RouteTemplateID", objRouteTemplateLine.RouteTemplateID));
sqlListParam.Add(new SqlParameter("@RouteTemplateCode", objRouteTemplateLine.RouteTemplateCode));
sqlListParam.Add(new SqlParameter("@RouteTemplateCode", objRouteTemplateLine.RouteTemplateCode));
sqlListParam.Add(new SqlParameter("@SeqLineNo", objRouteTemplateLine.SeqLineNo));
sqlListParam.Add(new SqlParameter("@TransferFromCode", objRouteTemplateLine.TransferFromCode));
sqlListParam.Add(new SqlParameter("@TransferToCode", objRouteTemplateLine.TransferToCode));
sqlListParam.Add(new SqlParameter("@JarakTempuh", objRouteTemplateLine.JarakTempuh));
sqlListParam.Add(new SqlParameter("@BiayaToll", objRouteTemplateLine.BiayaToll));
sqlListParam.Add(new SqlParameter("@BiayaBBM", objRouteTemplateLine.BiayaBBM));
sqlListParam.Add(new SqlParameter("@Retribusi", objRouteTemplateLine.Retribusi));
sqlListParam.Add(new SqlParameter("@BiayaLainLain", objRouteTemplateLine.BiayaLainLain));
sqlListParam.Add(new SqlParameter("@RowStatus", objRouteTemplateLine.RowStatus));
sqlListParam.Add(new SqlParameter("@CreatedBy", objRouteTemplateLine.CreatedBy));
DataAccess dataAccess = new DataAccess(Global.AllVisionsCS);
int intResult = dataAccess.ProcessData(sqlListParam, "spRouteTemplateLineEdit");
strError = dataAccess.Error;
return(intResult);
}
catch (Exception ex)
{
strError = ex.Message;
return(-1);
}
}
public RouteTemplateLine GenerateRouteTemplateLineObject(SqlDataReader sqlDataReader)
{
objRouteTemplateLine = new RouteTemplateLine();
objRouteTemplateLine.RouteTemplateLineID = Convert.ToInt32(sqlDataReader["RouteTemplateLineID"]);
objRouteTemplateLine.RouteTemplateID = Convert.ToInt32(sqlDataReader["RouteTemplateID"]);
objRouteTemplateLine.RouteTemplateCode = sqlDataReader["RouteTemplateCode"].ToString();
objRouteTemplateLine.RouteTemplateCode = sqlDataReader["RouteTemplateCode"].ToString();
objRouteTemplateLine.SeqLineNo = Convert.ToInt32(sqlDataReader["SeqLineNo"]);
objRouteTemplateLine.TransferFromCode = sqlDataReader["TransferFromCode"].ToString();
objRouteTemplateLine.TransferToCode = sqlDataReader["TransferToCode"].ToString();
objRouteTemplateLine.JarakTempuh = Convert.ToDecimal(sqlDataReader["JarakTempuh"]);
objRouteTemplateLine.BiayaToll = Convert.ToDecimal(sqlDataReader["BiayaToll"]);
objRouteTemplateLine.BiayaBBM = Convert.ToDecimal(sqlDataReader["BiayaBBM"]);
objRouteTemplateLine.Retribusi = Convert.ToDecimal(sqlDataReader["Retribusi"]);
objRouteTemplateLine.BiayaLainLain = Convert.ToDecimal(sqlDataReader["BiayaLainLain"]);
objRouteTemplateLine.RowStatus = (short)sqlDataReader["RowStatus"];
objRouteTemplateLine.CreatedBy = sqlDataReader["CreatedBy"].ToString();
if (sqlDataReader["CreatedTime"] != null && sqlDataReader["CreatedTime"].ToString() != "")
{
objRouteTemplateLine.CreatedTime = Convert.ToDateTime(sqlDataReader["CreatedTime"]);
}
objRouteTemplateLine.LastModifiedBy = sqlDataReader["LastModifiedBy"].ToString();
if (sqlDataReader["LastModifiedTime"] != null && sqlDataReader["LastModifiedTime"].ToString() != "")
{
objRouteTemplateLine.LastModifiedTime = Convert.ToDateTime(sqlDataReader["LastModifiedTime"]);
}
return(objRouteTemplateLine);
}
public int getLastLineNo(RouteTemplateLine RouteTemplateLine)
{
DataAccess dataAccess = new DataAccess(Global.AllVisionsCS);
SqlDataReader sqlDataReader = dataAccess.RetrieveDataByString("Select IsNull(Max(SeqLineNo),0) as SeqLineNo from RouteTemplateLine WITh (NOLOCK) WHERE RouteTemplateID = " + RouteTemplateLine.RouteTemplateID + " AND RowStatus = 0 order by SeqLineNo Desc");
strError = dataAccess.Error;
if (sqlDataReader.HasRows)
{
while (sqlDataReader.Read())
{
return(Convert.ToInt32(sqlDataReader["SeqLineNo"]));
}
}
return(0);
}
public RouteTemplateLine RetrieveRouteTemplateLineByID(RouteTemplateLine RouteTemplateLine, int intRouteTemplateLineID)
{
DataAccess dataAccess = new DataAccess(Global.AllVisionsCS);
SqlDataReader sqlDataReader = dataAccess.RetrieveDataByString("Select * from RouteTemplateLine WITh (NOLOCK) WHERE RouteTemplateLineID = '" + intRouteTemplateLineID + "' and RowStatus = 0");
strError = dataAccess.Error;
if (sqlDataReader.HasRows)
{
while (sqlDataReader.Read())
{
return(GenerateRouteTemplateLineObject(sqlDataReader));
}
}
return(RouteTemplateLine);
}
public RouteTemplateLine RetrieveRouteTemplateLineByUniqueID(RouteTemplateLine RouteTemplateLine, string DocumentNo, int SeqLineNo, int intDocumentType)
{
DataAccess dataAccess = new DataAccess(Global.AllVisionsCS);
SqlDataReader sqlDataReader = dataAccess.RetrieveDataByString("Select * from RouteTemplateLine WITh (NOLOCK) WHERE DocumentNo = '" + DocumentNo + "' AND DocumentType = " + intDocumentType + " AND SeqLineNo = '" + SeqLineNo + "' and RowStatus = 0");
strError = dataAccess.Error;
if (sqlDataReader.HasRows)
{
while (sqlDataReader.Read())
{
return(GenerateRouteTemplateLineObject(sqlDataReader));
}
}
return(RouteTemplateLine);
}
void ClearLine()
{
routeTemplateLine = new RouteTemplateLine();
routeTemplateLine.RouteTemplateID = routeTemplate.RouteTemplateID;
routeTemplateLine.RouteTemplateCode = routeTemplate.Name;
routeTemplateLine.TransferFromCode = "";
routeTemplateLine.TransferToCode = "";
routeTemplateLine.JarakTempuh = 0;
routeTemplateLine.BiayaToll = 0;
routeTemplateLine.BiayaBBM = 0;
routeTemplateLine.Retribusi = 0;
routeTemplateLine.BiayaLainLain = 0;
CurrentLineItem();
}
public ArrayList RetrieveRouteTemplateLineByDocTypeNoandQty(RouteTemplateLine RouteTemplateLine, int intDocumentType, string DocumentNo)
{
DataAccess dataAccess = new DataAccess(Global.AllVisionsCS);
SqlDataReader sqlDataReader = dataAccess.RetrieveDataByString("Select * from RouteTemplateLine WITh (NOLOCK) WHERE DocumentType = " + intDocumentType + " AND DocumentNo = '" + DocumentNo + "' AND Quantity <> 0 order by isnull(LastModifiedTime, CreatedTime) desc ");
strError = dataAccess.Error;
arrRouteTemplateLine = new ArrayList();
if (sqlDataReader.HasRows)
{
while (sqlDataReader.Read())
{
arrRouteTemplateLine.Add(GenerateRouteTemplateLineObject(sqlDataReader));
}
}
return(arrRouteTemplateLine);
}
private void dgvRouteTemplateLine_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
{
routeTemplateLine = RouteTemplateLineMgmt.RetrieveRouteTemplateLineByID(routeTemplateLine, Convert.ToInt32(dgvRouteTemplateLine.Rows[e.RowIndex].Cells[0].Value));
CurrentLineItem();
}
