public bool SaveTerritoryTargets(mdlTerritoryTargets obj_mdlTerritoryTargets)
{
bool Save = false;
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
SqlCommand cmd = new SqlCommand();
SqlTransaction transaction = con.BeginTransaction();
try
{
if (obj_mdlTerritoryTargets.dtSalemanCmpanyWiseTargets.Rows.Count > 0)
{
cmd = new SqlCommand("Delete from D_Targets_Saleman_Company where FK_TerritoryId = '" + obj_mdlTerritoryTargets.TerritoryID + "' and TargetMonth = '" + obj_mdlTerritoryTargets.TargetMonth + "' and TargetYear = '" + obj_mdlTerritoryTargets.TargetYear + "'", con, transaction);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
for (int i = 0; i <= obj_mdlTerritoryTargets.dtSalemanCmpanyWiseTargets.Rows.Count - 1; i++)
{
if (obj_mdlTerritoryTargets.dtSalemanCmpanyWiseTargets.Rows[i].RowState != DataRowState.Deleted)
{
cmd = new SqlCommand("stp_ERP_INSERT_D_Targets_Saleman_Company", con, transaction);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.Add("@Fk_TerritoryID", SqlDbType.VarChar, 6).Value = obj_mdlTerritoryTargets.TerritoryID;
cmd.Parameters.Add("@TargetMonth", SqlDbType.VarChar, 2).Value = obj_mdlTerritoryTargets.TargetMonth;
cmd.Parameters.Add("@TargetYear", SqlDbType.VarChar, 4).Value = obj_mdlTerritoryTargets.TargetYear;
cmd.Parameters.Add("@AddUser", SqlDbType.VarChar, 16).Value = obj_mdlTerritoryTargets.AddUser;
cmd.Parameters.Add("@AddComputer", SqlDbType.VarChar, 20).Value = obj_mdlTerritoryTargets.LoginComputer;
cmd.Parameters.Add("@Fk_EmployeeID", SqlDbType.VarChar, 6).Value = obj_mdlTerritoryTargets.dtSalemanCmpanyWiseTargets.Rows[i]["Employee ID"].ToString();
cmd.Parameters.Add("@CompanyID", SqlDbType.VarChar, 3).Value = obj_mdlTerritoryTargets.dtSalemanCmpanyWiseTargets.Rows[i]["Comp. ID"].ToString();
cmd.Parameters.Add("@TargetValue", SqlDbType.Decimal, 18).Value = obj_mdlTerritoryTargets.dtSalemanCmpanyWiseTargets.Rows[i]["Target Value"].ToString();
cmd.ExecuteNonQuery();
}
}
if (obj_mdlTerritoryTargets.dtSalemanProductWiseTargets.Rows.Count > 0)
{
cmd = new SqlCommand("Delete from D_Targets_Saleman_Product where FK_TerritoryId = '" + obj_mdlTerritoryTargets.TerritoryID + "' and TargetMonth = '" + obj_mdlTerritoryTargets.TargetMonth + "' and TargetYear = '" + obj_mdlTerritoryTargets.TargetYear + "'", con, transaction);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
for (int i = 0; i <= obj_mdlTerritoryTargets.dtSalemanProductWiseTargets.Rows.Count - 1; i++)
{
if (obj_mdlTerritoryTargets.dtSalemanProductWiseTargets.Rows[i].RowState != DataRowState.Deleted)
{
cmd = new SqlCommand("stp_ERP_INSERT_D_Targets_Saleman_Product", con, transaction);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.Add("@Fk_TerritoryID", SqlDbType.VarChar, 6).Value = obj_mdlTerritoryTargets.TerritoryID;
cmd.Parameters.Add("@TargetMonth", SqlDbType.VarChar, 2).Value = obj_mdlTerritoryTargets.TargetMonth;
cmd.Parameters.Add("@TargetYear", SqlDbType.VarChar, 4).Value = obj_mdlTerritoryTargets.TargetYear;
cmd.Parameters.Add("@AddUser", SqlDbType.VarChar, 16).Value = obj_mdlTerritoryTargets.AddUser;
cmd.Parameters.Add("@AddComputer", SqlDbType.VarChar, 20).Value = obj_mdlTerritoryTargets.LoginComputer;
cmd.Parameters.Add("@Fk_ProductID", SqlDbType.VarChar, 6).Value = obj_mdlTerritoryTargets.dtSalemanProductWiseTargets.Rows[i]["Product ID"].ToString();
cmd.Parameters.Add("@TargetQty", SqlDbType.Decimal, 18).Value = obj_mdlTerritoryTargets.dtSalemanProductWiseTargets.Rows[i]["Target Qty."].ToString();
cmd.ExecuteNonQuery();
}
}
transaction.Commit();
Save = true;
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
catch (Exception ex)
{
transaction.Rollback();
MessageBox.Show(ex.Message, "ERP - Babar Medicine Company Lahore", MessageBoxButtons.OK, MessageBoxIcon.Error);
Save = false;
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return Save;
}
public bool SaveTerritoryTargets(mdlTerritoryTargets obj_mdlTerritoryTargets)
{
return obj_dalTerritoryTargets.SaveTerritoryTargets(obj_mdlTerritoryTargets);
}
