public void SaveProductCounterMapping(string Counter)
{
StringBuilder strSql = new StringBuilder();
int i = 0;
strSql.Append("Delete from [ERP].[ProductCounterMapping] where CounterId ='" + Counter + "' \n");
foreach (ProductCounterMappingList det in this.ModelProductCounterMappingList)
{
strSql.Append("INSERT INTO [ERP].[ProductCounterMapping](CounterId, ProductId) values ('" + Counter + "','" + det.ProductId + "') \n");
i++;
}
ModelProductMappingList.Clear();
DAL.ExecuteNonQuery(System.Data.CommandType.Text, strSql.ToString());
}
//------------ START PRODUCT MAPPING --------
public void SaveProductMapping(string Module)
{
StringBuilder strSql = new StringBuilder();
int i = 0;
foreach (ProductMappingList det in this.ModelProductMappingList)
{
if (Module == "ProductGroup")
{
strSql.Append("UPDATE ERP.Product set ProductGrpId='" + det.ProductGrpId + "' where ProductId='" + det.ProductId + "' \n");
}
else if (Module == "ProductSubGroup")
{
strSql.Append("UPDATE ERP.Product set ProductGrpId='" + det.ProductGrpId + "',ProductSubGrpId = '" + det.ProductSubGrpId + "' where ProductId='" + det.ProductId + "' \n");
}
else if (Module == "Branch")
{
if (i == 0)
{
strSql.Append("Delete from [ERP].[ProductBranchUnitMapping] where BranchId ='" + det.BranchId + "' \n");
}
strSql.Append("INSERT INTO [ERP].[ProductBranchUnitMapping] (ProductId, BranchId, CompanyUnitId) \n");
strSql.Append("Select '" + det.ProductId + "','" + det.BranchId + "',null \n");
}
else if (Module == "CompanyUnit")
{
if (i == 0)
{
strSql.Append("Delete from [ERP].[ProductBranchUnitMapping] where CompanyUnitId ='" + det.CompanyUnitId + "' \n");
}
strSql.Append("INSERT INTO [ERP].[ProductBranchUnitMapping] (ProductId, BranchId, CompanyUnitId) \n");
strSql.Append("Select '" + det.ProductId + "','" + det.BranchId + "','" + det.CompanyUnitId + "' \n");
}
i++;
}
ModelProductMappingList.Clear();
DAL.ExecuteNonQuery(System.Data.CommandType.Text, strSql.ToString());
}