//product insert method//
public string productInsert(string ProductCode, string MappingCode, string Src_Product_Type, string Des_Product_Type)
{
DataControl.Data ds = new DataControl.Data();
try
{
string Result = string.Empty;
//string salesproductCode = string.Empty;
//salesproductCode = collection["ProductCode"];
string effectiveFrom = string.Empty;
effectiveFrom = DateTime.Now.ToString("yyyy-MM-dd");
string effectiveTo = string.Empty;
effectiveTo = DateTime.Now.ToString("yyyy-MM-dd");
string createdDate = string.Empty;
createdDate = DateTime.Now.ToString("yyyy-MM-dd");
string createdBy = string.Empty;
string mappingproductCode = string.Empty;
string insertQry = string.Empty;
//string[] arMapping = collection["MappingCode"].ToString().Split('^');
string CompanyCode = objCurrentInfo.GetCompanyCode();
string UserCode = objCurrentInfo.GetUserCode();
DataRow[] rowFilter;
//dsMappingDetails =
DataSet dsMappingDetails = new DataSet();
//ds.OpenConnection(CompanyCode);
//{
// string StrSQL = "EXEC SP_hdGetSalesProductmapping " + "'" + CompanyCode + "','" + ProductCode + "'";
// dsMappingDetails = ds.ExecuteDataSet(StrSQL);
//}
ds.OpenConnection(CompanyCode);
{
string StrSQL = "EXEC Sp_hdSalesProductHistory" + "'" + CompanyCode + "','" + ProductCode + "','" + MappingCode + "','" + UserCode + "','" + Src_Product_Type + "','" + Des_Product_Type + "'";
dsMappingDetails = ds.ExecuteDataSet(StrSQL);
}
//foreach (string mappingCode in arMapping)
//{
// if (!string.IsNullOrEmpty(mappingCode))
// {
// rowFilter = dsMappingDetails.Tables[0].Select("Mapping_Product_Code = '" + mappingCode.Split('|')[0] + "' AND Record_Status = '1'");
// if (rowFilter.Length > 0 && mappingCode.Split('|')[1].Trim().ToUpper() == "F")
// {
// insertQry += "UPDATE tbl_SFA_Sales_Product_Mapping SET Record_Status = '0',Effective_To = '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff") + "'";
// insertQry += " WHERE Sales_Product_Code = '" + salesproductCode + "' AND Mapping_Product_Code = '" + mappingCode.Split('|')[0].Trim() + "' AND Company_Code = '" + objCurrentInfo.GetCompanyCode() + "';";
// }
// else if (rowFilter.Length > 0 && mappingCode.Split('|')[1].Trim().ToUpper() == "T")
// {
// insertQry += " WHERE Sales_Product_Code = '" + salesproductCode + "' AND Mapping_Product_Code = '" + mappingCode.Split('|')[0].Trim() + "' AND Company_Code = '" + objCurrentInfo.GetCompanyCode() + "';";
// }
// else
// {
// if (mappingCode.Split('|')[1].Trim() == "T")
// {
// rowFilter = dsMappingDetails.Tables[0].Select("Mapping_Product_Code = '" + mappingCode.Split('|')[0] + "' AND Record_Status = '0'");
// if (rowFilter.Length > 0 && effectiveTo = DateTime.Now.ToString("yyyy-MM-dd"))
// {
// insertQry += "UPDATE tbl_SFA_Sales_Product_Mapping SET Record_Status = '1',Effective_From = '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff") + "'";
// insertQry += " WHERE Sales_Product_Code = '" + salesproductCode + "' AND Mapping_Product_Code = '" + mappingCode.Split('|')[0].Trim() + "' AND Company_Code = '" + objCurrentInfo.GetCompanyCode() + "';";
// }
// else
// {
// insertQry += "INSERT INTO tbl_SFA_Sales_Product_Mapping (Company_Code,Sales_Product_Code,Mapping_Product_Code,Effective_From,Created_Date,Created_By,Record_Status)";
// insertQry += "VALUES ('" + objCurrentInfo.GetCompanyCode() + "','" + salesproductCode + "','" + mappingCode.Split('|')[0].Trim() + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff") + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff") + "','" + objCurrentInfo.GetUserCode() + "','1');";
// }
// }
// }
// }
//}
if (!string.IsNullOrEmpty(insertQry))
{
insertQry = insertQry.TrimEnd(';');
}
DataControl.SPData objSpData = new DataControl.SPData();
int returnValue = objSpData.InsertSalesProductMapping(insertQry);
if (returnValue == 1)
{
return("SUCCESS");
}
else
{
return("SORRY. UNABLE TO SAVE DATA");
}
}
catch (Exception ex)
{
ErrorLog.LogError(ex, "productInsert()");
return(ex.Message);
}
finally
{
ds.CloseConnection();
}
}