public bool Resubmitproductdata(List <MVCModels.UserProductModel> lstuserproduct)
{
_objDALPromotionalInput = new DALPromotionalInput();
// List<MVCModels.Reportuserhierarchy> lstuserdisable = new List<MVCModels.Reportuserhierarchy>();
// string[] userdisable = null;
DataTable dtdisable = null;
if (lstuserproduct.Count >= 1)
{
dtdisable = new DataTable();
dtdisable.Columns.Add("ID", typeof(int));
dtdisable.Columns.Add("SourceUserCode", typeof(string));
dtdisable.Columns.Add("DestinationUserCode", typeof(string));
dtdisable.Columns.Add("Product_Code", typeof(string));
dtdisable.Columns.Add("Trans_Id", typeof(int));
dtdisable.Columns.Add("Remarks", typeof(string));
int j = 0;
for (int i = 0; i < lstuserproduct.Count; i++)
{
j++;
dtdisable.Rows.Add(j, lstuserproduct[i].SourceUserCode,
lstuserproduct[i].DestinationUserCode,
lstuserproduct[i].Product_Code,
lstuserproduct[i].Trans_Id,
lstuserproduct[i].Remarks);
}
}
return(_objDALPromotionalInput.Resubmitproductdata(lstuserproduct, dtdisable));
}
public bool Canceluserrequest(string companyCode, string usercode, int companyid, List <MVCModels.UserProductModel> lstuserproduct)
{
_objDALPromotionalInput = new DALPromotionalInput();
// List<MVCModels.Reportuserhierarchy> lstuserdisable = new List<MVCModels.Reportuserhierarchy>();
// string[] userdisable = null;
DataTable dtdisable = null;
if (lstuserproduct.Count >= 1)
{
dtdisable = new DataTable();
dtdisable.Columns.Add("ID", typeof(int));
dtdisable.Columns.Add("Company_Code", typeof(string));
dtdisable.Columns.Add("SourceUserCode", typeof(string));
dtdisable.Columns.Add("SourceUserName", typeof(string));
dtdisable.Columns.Add("DestinationUserCode", typeof(string));
dtdisable.Columns.Add("DestinationUserName", typeof(string));
dtdisable.Columns.Add("RequestedBy", typeof(string));
dtdisable.Columns.Add("Status", typeof(int));
dtdisable.Columns.Add("Remarks", typeof(string));
dtdisable.Columns.Add("CompanyId", typeof(int));
dtdisable.Columns.Add("UserCode", typeof(string));
dtdisable.Columns.Add("Logical_Quantity", typeof(int));
dtdisable.Columns.Add("Variance_Count", typeof(int));
dtdisable.Columns.Add("Physical_Quantity", typeof(int));
dtdisable.Columns.Add("ProductCode", typeof(string));
dtdisable.Columns.Add("Batch_Number", typeof(string));
dtdisable.Columns.Add("Approved_By", typeof(string));
dtdisable.Columns.Add("Approved_Date", typeof(string));
dtdisable.Columns.Add("Product_Name", typeof(string));
dtdisable.Columns.Add("Product_Type_Code", typeof(string));
dtdisable.Columns.Add("Product_Type_Name", typeof(string));
dtdisable.Columns.Add("Delivery_Challan_Number", typeof(string));
dtdisable.Columns.Add("Trans_Id", typeof(int));
int j = 0;
for (int i = 0; i < lstuserproduct.Count; i++)
{
j++;
dtdisable.Rows.Add(j, companyCode, lstuserproduct[i].SourceUserCode,
lstuserproduct[i].SourceUserName,
lstuserproduct[i].DestinationUserCode,
lstuserproduct[i].DestinationUserName,
usercode,
lstuserproduct[i].Status,
lstuserproduct[i].Remarks,
companyid,
usercode,
lstuserproduct[i].Logical_Quantity,
lstuserproduct[i].Variance_Count,
lstuserproduct[i].Physical_Quantity, lstuserproduct[i].Product_Code,
lstuserproduct[i].Batch_Number, lstuserproduct[i].Approved_By,
lstuserproduct[i].Approved_Date, lstuserproduct[i].Product_Name, lstuserproduct[i].Product_Type_Code,
lstuserproduct[i].Product_Type_Name, lstuserproduct[i].Delivery_Challan_Number, lstuserproduct[i].Trans_Id);
}
}
return(_objDALPromotionalInput.Canceluserrequest(companyCode, usercode, companyid, lstuserproduct, dtdisable));
}
public bool RejectUserRequest(string companyCode, string usercode, List <MVCModels.RejectedRequestModel> lstuserproduct)
{
_objDALPromotionalInput = new DALPromotionalInput();
// List<MVCModels.Reportuserhierarchy> lstuserdisable = new List<MVCModels.Reportuserhierarchy>();
// string[] userdisable = null;
DataTable dtdisable = null;
if (lstuserproduct.Count >= 1)
{
dtdisable = new DataTable();
dtdisable.Columns.Add("ID", typeof(int));
// dtdisable.Columns.Add("Company_Code", typeof(string));
// dtdisable.Columns.Add("Status", typeof(int));
dtdisable.Columns.Add("Rejected_Remarks", typeof(string));
dtdisable.Columns.Add("Trans_Id", typeof(int));
dtdisable.Columns.Add("Product_Code", typeof(string));
int j = 0;
for (int i = 0; i < lstuserproduct.Count; i++)
{
j++;
dtdisable.Rows.Add(j, // companyCode, //lstuserproduct[i].SourceUserCode,
// lstuserproduct[i].SourceUserName,
// lstuserproduct[i].DestinationUserCode,
// lstuserproduct[i].DestinationUserName,
// usercode,
//lstuserproduct[i].Status,
lstuserproduct[i].Rejected_Remarks,
lstuserproduct[i].Trans_Id,
lstuserproduct[i].Product_Code);
}
}
return(_objDALPromotionalInput.RejectUserRequest(companyCode, usercode, lstuserproduct, dtdisable));
}
public IEnumerable <MVCModels.ViewTransferModel> GetUserDetailsOnView(string companyCode, string usercode, string username, string sourceusercode, string destinationusercode, int transferid)
{
_objDALPromotionalInput = new DALPromotionalInput();
return(_objDALPromotionalInput.GetUserDetailsOnView(companyCode, usercode, username, sourceusercode, destinationusercode, transferid));
}
public IEnumerable <MVCModels.promotionalApprovalModel> GetUsersForApproval(string companyCode, string usercode)
{
_objDALPromotionalInput = new DALPromotionalInput();
return(_objDALPromotionalInput.GetUsersForApproval(companyCode, usercode));
}
public IEnumerable <MVCModels.Productmodel> GetRejectedUserProductdata(string companyCode, string UserCode, string username, string sourceusercode, string destinationusercode, int transferid)
{
_objDALPromotionalInput = new DALPromotionalInput();
return(_objDALPromotionalInput.GetRejectedUserProductdata(companyCode, UserCode, username, sourceusercode, destinationusercode, transferid).ToList());
}
public IEnumerable <MVCModels.PromotionalInputUserModel> GetUsersdata(string companyCode, string usercode)
{
_objDALPromotionalInput = new DALPromotionalInput();
return(_objDALPromotionalInput.GetUsersdata(companyCode, usercode));
}
public IEnumerable <MVCModels.promotionalApprovalModel> GetRemarksHistory(string companyCode, int TransId, string Product_Code)
{
_objDALPromotionalInput = new DALPromotionalInput();
return(_objDALPromotionalInput.GetRemarksHistory(companyCode, TransId, Product_Code));
}
public string Deliverychallan(string CompanyCode, string Deliverychallanno)
{
_objDALPromotionalInput = new DALPromotionalInput();
return(_objDALPromotionalInput.Deliverychallan(CompanyCode, Deliverychallanno));
}
public IEnumerable <MVCModels.Productmodel> GetUserProductdata(string companyCode, string UserCode)
{
_objDALPromotionalInput = new DALPromotionalInput();
return(_objDALPromotionalInput.GetUserProductdata(companyCode, UserCode));
}
public IEnumerable <MVCModels.PromotionalInputUserModel> GetUsers(string companyCode, string usercode, string effective_from, string effective_to)
{
_objDALPromotionalInput = new DALPromotionalInput();
return(_objDALPromotionalInput.GetUsers(companyCode, usercode, effective_from, effective_to));
}