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