public int Update_RPD(BatchPackingMR obj, MTN.Status MTNState, MTN.Type MTNType, MTN.ItemType MTNItemType, string EnteredBy)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@BatchID", obj.BatchID),
new SqlParameter("@BatchUsed", obj.BatchUsed),
new SqlParameter("@BatchDamaged", obj.BatchDamaged),
new SqlParameter("@BatchReturned", obj.BatchReturned),
new SqlParameter("@State", obj.State),
new SqlParameter("@MTNStatus", Convert.ToInt32(MTNState)),
new SqlParameter("@MTNType", Convert.ToInt32(MTNType)),
new SqlParameter("@MTNItemType", Convert.ToInt32(MTNItemType)),
new SqlParameter("@EnteredBy", EnteredBy),
new SqlParameter("@IssuedBy", Convert.ToInt32(MTNType)),
new SqlParameter("@StartQty", obj.StartQty),
new SqlParameter("@ID", obj.ID)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_BatchPackingMR_RPD", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public System.Data.DataTable GetDataViewByStateAndType(MTN.Status Status, MTN.Type Type)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MTNStatus", Status),
new SqlParameter("@MTNType", Type)
};
return(Execute.RunSP_DataTable(Connection, "SPGET_MTNByTypeAndState", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public System.Data.DataTable GetDataView(long UserID, MTN.Status Status, MTN.Type MTNType)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@UserID", UserID),
new SqlParameter("@MTNType", MTNType),
new SqlParameter("@Status", Status)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MTN_ByFromDep_Status_Type", paramList);
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
