public string Index(FormCollection form)
{
string result = "";
HttpPostedFileBase file = Request.Files[0];
DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
MVCModels.RCPA_Header objrcpaHeader = new MVCModels.RCPA_Header();
objrcpaHeader.Company_Id = Convert.ToInt32(_objCurInfo.GetCompanyId());
objrcpaHeader.Company_code = _objCurInfo.GetCompanyCode();
objrcpaHeader.user_code = _objCurInfo.GetUserCode();
// objrcpaHeader.Region_Code = _objCurInfo.GetRegionCode();
// objrcpaHeader.PeriodTo = DateTime.Now;
//objrcpaHeader.PeriodFrom = DateTime.Now;
try
{
DateTime dt = DateTime.ParseExact(Request.Form["txtPeriodFrom"].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture);
objrcpaHeader.PeriodFrom = Convert.ToDateTime(dt.ToString("yyyy-MM-dd"));
dt = DateTime.ParseExact(Request.Form["txtPeriodTo"].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture);
objrcpaHeader.PeriodTo = Convert.ToDateTime(dt);
objrcpaHeader.Region_Code = Request.Form["hdnRegion_Code"].ToString();
string subDomain = _objCurInfo.GetSubDomain();
result = _objBLRCPACompetator.RCPAExcelBulkAddResult(subDomain, _objCurInfo.GetCompanyCode(), _objCurInfo.GetRegionCode(), Guid.NewGuid().ToString(), file, _objCurInfo.GetUserCode(), objrcpaHeader);
ViewBag.ErrorCode = result;
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
ViewBag.Companycode = objCurInfo.GetCompanyCode();
ViewBag.RegionCode = objCurInfo.GetRegionCode();
}
catch (Exception ex)
{
result = ex.Message;
}
return(result);
}
public string RCPAExcelBulkAddResult(string subDomain, string companyCode, string Regioncode, string guid, System.Web.HttpPostedFileBase postedFile, string uploadedBy, MVCModels.RCPA_Header objrcpaHeader)
{
string result = "";
try
{
DataTable dt = ConvertRCPAExcelToDataTable(postedFile);
if (dt == null)
{
result = "ERROR:NO DATA found in the uploaded excel file";
}
else if (dt.Rows.Count == 0)
{
result = "ERROR:NO DATA found in the uploaded excel file";
}
else
{
//dt.Columns.Add("Company_Code", typeof(String));
//dt.Columns.Add("Region_Code", typeof(String));
//dt.Columns.Add("GUID", typeof(String));
//dt.Columns.Add("Status", typeof(String));
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// dt.Rows[i]["Company_Code"] = companyCode;
// dt.Rows[i]["Region_Code"] = Regioncode;
// dt.Rows[i]["GUID"] = guid.ToString();
// dt.Rows[i]["Status"] = "PROCESSING";
//}
List <RCPA_Doctor> lsRCPA_Doctor = new List <RCPA_Doctor>();
List <RCPA_SalesProduct> lsRCPA_SalesProduct = new List <RCPA_SalesProduct>();
List <RCPA_CompProduct> lsRCPA_CompProduct = new List <RCPA_CompProduct>();
List <string> columnName = new List <string>();
for (int j = 0; j < dt.Columns.Count; j++)
{
columnName.Add(dt.Columns[j].ColumnName.ToString());
}
var Count = 0;
foreach (DataRow row in dt.Rows)
{
string Doctor_name = "";
string SalesProduct_Name = "";
int sale_Product_Count = 0;
int Com_Product_Count = 0;
//GetDoctor Name
for (int i = 0; i < columnName.Count; i++)
{
var name = columnName[i].ToString().Split('_');
if (name.Length > 1)
{
if (name[0].ToUpper() == "D")
{
Count++;
lsRCPA_Doctor.Add(new RCPA_Doctor {
Doctor_Name = row["D_Doctor_Name"].ToString(), Row_Number = Count
});
Doctor_name = row["D_Doctor_Name"].ToString();
}
else if (name[0].ToUpper() == "S")
{
sale_Product_Count++;
Com_Product_Count = 0;
lsRCPA_SalesProduct.Add(new RCPA_SalesProduct {
SalesProduct_Name = name[1], Product_Quantity = row[(name[0] + "_" + name[1])].ToString(), Doctor_Name = Doctor_name, Row_No = sale_Product_Count
});
SalesProduct_Name = name[1];
}
else if (name[0].ToUpper() == "C")
{
Com_Product_Count++;
lsRCPA_CompProduct.Add(new RCPA_CompProduct {
SalesProduct_Name = SalesProduct_Name, Comp_Product_Name = name[1], Product_Quantity = row[(name[0] + "_" + name[1])].ToString(), Doctor_Name = Doctor_name, Row_No = Com_Product_Count
});
}
else if (name[0] == "K")
{
}
}
}
}
result = _objDALRCPACompetator.RCPAInsert(lsRCPA_Doctor, lsRCPA_SalesProduct, lsRCPA_CompProduct, objrcpaHeader);
//result = _objDALRCPACompetator.RCPAExcelBulkInsert(companyCode, dt);
// if (result == "SUCCESS")
// {
// result = _objDALRCPACompetator.RCPAExcelBulkAddResult(subDomain, companyCode, Regioncode, guid, _employeeExcelTemplateFileName, uploadedBy, "EMPLOYEE_UPLOAD");
//// }
// else
// {
///// result = "ERROR:Instructions are not followed." + result;
// }
}
}
catch (Exception ex)
{
result = "ERROR:Instructions not followed." + ex.Message;
}
return(result);
}
