public int Update(long GRNNO, GRN.Status Status)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@GRNNO", GRNNO),
new SqlParameter("@GRNStatus", Status)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_GRN_STATUS", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public System.Data.DataTable GetDataView(int GNRType, GRN.Status Status)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Type", GNRType),
new SqlParameter("@Status", Status)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_GRN_DataviewByTypeAndStatus", paramList);
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int AddGRN(long MTNNO, MTN.Status MTNstatus, String GRNBy, string StoreID, GRN.Type GRNType, GRN.Status GRNStatus)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MTNNO", MTNNO),
new SqlParameter("@MTNStatus", MTNstatus),
new SqlParameter("@GRNBy", GRNBy),
new SqlParameter("@StoreID", StoreID),
new SqlParameter("@GRNType", Convert.ToInt32(GRNType)),
new SqlParameter("@GRNStatus", Convert.ToInt32(GRNStatus)),
new SqlParameter("@outParam", SqlDbType.Int)
{
Direction = ParameterDirection.Output
}
};
return(Execute.RunSP_Output(Connection, "SPUPDATE_MTN_GRN", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public System.Data.DataTable GetDataView(long DepID, DateTime From, DateTime To, GRN.Status Status)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Status", Status),
new SqlParameter("@DateFrom", From),
new SqlParameter("@DateTo", To),
new SqlParameter("@DepID", DepID)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_GRN_Manage", paramList);
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}