internal static DataTable getTargetUnitTrans(TargetEntryBO TarentBO)
{
BsfGlobal.OpenCRMDB();
string ssql = "";
DataTable dtTarReg = null;
SqlDataAdapter da = null;
try
{
ssql = String.Format("Select TargetTransId, TargetId, B.UserId, B.EmployeeName, TMonth, TYear, TValue from TargetAmtTrans A" +
" Inner Join [" + BsfGlobal.g_sWorkFlowDBName + "].dbo.Users B ON A.ExecutiveId=B.UserId Where TargetId={0}", TarentBO.i_TargetId);
da = new SqlDataAdapter(ssql, BsfGlobal.g_CRMDB);
dtTarReg = new DataTable();
da.Fill(dtTarReg);
}
catch (Exception e)
{
BsfGlobal.CustomException(e.Message, e.StackTrace);
}
finally
{
BsfGlobal.g_CRMDB.Close();
}
return(dtTarReg);
}
internal static DataTable InsertIncentiveTrans(string s_Mode, DataTable dt, TargetEntryBO TargetBO)
{
BsfGlobal.OpenCRMDB();
string ssql = "";
DataTable dtIncenTrans = null;
SqlCommand sCmd;
try
{
//if (s_Mode == "A")
//{
ssql = "Delete From IncentiveTrans Where TargetId=" + TargetBO.i_TargetId + "";
sCmd = new SqlCommand(ssql, BsfGlobal.g_CRMDB);
sCmd.ExecuteNonQuery();
sCmd.Dispose();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (s_Mode == "A")
{
if (TargetBO.s_IncenType == "L")
{
ssql = String.Format("Insert into IncentiveTrans(TargetId, FromValue, ToValue, IncValue) Values({0} , {1}, {2}, {3})", TargetBO.i_TargetId, CommFun.IsNullCheck(dt.Rows[i]["From"], CommFun.datatypes.vartypenumeric), CommFun.IsNullCheck(dt.Rows[i]["To"], CommFun.datatypes.vartypenumeric), CommFun.IsNullCheck(dt.Rows[i]["Amount"], CommFun.datatypes.vartypenumeric));
}
else
{
ssql = String.Format("Insert into IncentiveTrans(TargetId, FromValue, ToValue, IncValue) Values({0} , {1}, {2}, {3})", TargetBO.i_TargetId, CommFun.IsNullCheck(dt.Rows[i]["From"], CommFun.datatypes.vartypenumeric), CommFun.IsNullCheck(dt.Rows[i]["To"], CommFun.datatypes.vartypenumeric), CommFun.IsNullCheck(dt.Rows[i]["RateofIncentive"], CommFun.datatypes.vartypenumeric));
}
}
else
{
ssql = String.Format("Insert into IncentiveTrans(TargetId, FromValue, ToValue, IncValue) Values({0} , {1}, {2}, {3})", TargetBO.i_TargetId, CommFun.IsNullCheck(dt.Rows[i]["FromValue"], CommFun.datatypes.vartypenumeric), CommFun.IsNullCheck(dt.Rows[i]["ToValue"], CommFun.datatypes.vartypenumeric), CommFun.IsNullCheck(dt.Rows[i]["IncValue"], CommFun.datatypes.vartypenumeric));
}
sCmd = new SqlCommand(ssql, BsfGlobal.g_CRMDB);
sCmd.ExecuteNonQuery();
sCmd.Dispose();
}
//}
//else
//{
// ssql = String.Format("Update IncentiveTrans set FromValue={0}, ToValue={1}, IncValue={2} Where IncentiveId={3} AND TargetId={4}", dt.Rows[i]["FromValue"], dt.Rows[i]["ToValue"], dt.Rows[i]["IncValue"], TargetBO.i_IncentiveId, TargetBO.i_TargetId);
// sCmd = new SqlCommand(ssql, BsfGlobal.g_CRMDB);
// sCmd.ExecuteNonQuery();
//}
}
finally
{
BsfGlobal.g_CRMDB.Close();
}
return(dtIncenTrans);
}
internal static DataTable InsertTargetTrans(string s_Mode, TargetEntryBO TarEntBO)
{
BsfGlobal.OpenCRMDB();
string ssql = "";
DataTable dtTarTrans = null;
SqlCommand sCmd;
try
{
if (s_Mode == "A")
{
ssql = String.Format("Insert into TargetTrans(TargetId, ExecutiveId, TMonth, TYear, TValue) Values({0} , {1}, {2}, {3}, {4})", TarEntBO.i_TargetId, TarEntBO.i_ExeId, TarEntBO.i_TMonth, TarEntBO.i_TYear, TarEntBO.d_TValue);
sCmd = new SqlCommand(ssql, BsfGlobal.g_CRMDB);
sCmd.ExecuteNonQuery();
sCmd.Dispose();
ssql = "Insert into TargetAmtTrans(TargetId, ExecutiveId, TMonth, TYear, TValue) Values(" +
" " + TarEntBO.i_TargetId + "," + TarEntBO.i_ExeId + "," + TarEntBO.i_TMonth + "," + TarEntBO.i_TYear + "," +
" " + TarEntBO.d_UnitValue + ")";
sCmd = new SqlCommand(ssql, BsfGlobal.g_CRMDB);
sCmd.ExecuteNonQuery();
sCmd.Dispose();
}
else
{
ssql = String.Format("Update TargetTrans set ExecutiveId={0}, TMonth={1}, TYear={2},TValue={3} Where TargetTransId={4} AND TargetId={5}", TarEntBO.i_ExeId, TarEntBO.i_TMonth, TarEntBO.i_TYear, TarEntBO.d_TValue, TarEntBO.i_TargetTransId, TarEntBO.i_TargetId);
sCmd = new SqlCommand(ssql, BsfGlobal.g_CRMDB);
sCmd.ExecuteNonQuery();
sCmd.Dispose();
ssql = "Update TargetAmtTrans set ExecutiveId=" + TarEntBO.i_ExeId + ", TMonth=" + TarEntBO.i_TMonth + "," +
" TYear=" + TarEntBO.i_TYear + ",TValue=" + TarEntBO.d_UnitValue + " Where TargetTransId=" + TarEntBO.i_TargetTransUnitId + " " +
" AND TargetId=" + TarEntBO.i_TargetId + "";
sCmd = new SqlCommand(ssql, BsfGlobal.g_CRMDB);
sCmd.ExecuteNonQuery();
sCmd.Dispose();
}
}
finally
{
BsfGlobal.g_CRMDB.Close();
}
return(dtTarTrans);
}
internal static int InsertTargetMaster(string s_Mode, TargetEntryBO TarEntBO)
{
BsfGlobal.OpenCRMDB();
string ssql = "";
DataTable dtTarMas = null;
SqlDataAdapter sda;
SqlCommand sCmd;
string s_TarDate = "";
string s_FromDate = "";
int i_TargetId = 0;
try
{
s_TarDate = string.Format("{0:dd/MMM/yyyy}", TarEntBO.DE_TargetDate);
s_FromDate = string.Format("{0:dd/MMM/yyyy}", TarEntBO.DE_FromDate);
if (s_Mode == "A")
{
ssql = String.Format("Insert into TargetMaster(TargetDate, RefNo, FromDate, CostCentre, PeriodType, TargetType, Incentive, IncentiveType, IncentiveFrom, NoofPeriods) Values('{0}', '{1}', '{2}', {3}, '{4}', '{5}', {6}, '{7}', '{8}', {9}) SELECT SCOPE_IDENTITY();", s_TarDate, TarEntBO.s_RefNo, s_FromDate, TarEntBO.i_CostCentreId, TarEntBO.s_PeriodType, TarEntBO.s_TargetType, TarEntBO.d_Incentive, TarEntBO.s_IncenType, TarEntBO.s_Incentivefrom, TarEntBO.i_NoOfPeriod);
sda = new SqlDataAdapter(ssql, BsfGlobal.OpenCRMDB());
dtTarMas = new DataTable();
sda.Fill(dtTarMas);
i_TargetId = Convert.ToInt32(dtTarMas.Rows[0]["Column1"].ToString());
TarEntBO.i_TargetId = i_TargetId;
}
else
{
ssql = String.Format("Update TargetMaster set TargetDate='{0}', RefNo='{1}', FromDate='{2}', CostCentre={3}, PeriodType='{4}', TargetType='{5}', Incentive={6}, IncentiveType='{7}', IncentiveFrom='{8}', NoofPeriods={9} Where TargetId={10}", s_TarDate, TarEntBO.s_RefNo, s_FromDate, TarEntBO.i_CostCentreId, TarEntBO.s_PeriodType, TarEntBO.s_TargetType, TarEntBO.d_Incentive, TarEntBO.s_IncenType, TarEntBO.s_Incentivefrom, TarEntBO.i_NoOfPeriod, TarEntBO.i_TargetId);
sCmd = new SqlCommand(ssql, BsfGlobal.g_CRMDB);
sCmd.ExecuteNonQuery();
}
}
finally
{
BsfGlobal.g_CRMDB.Close();
}
return(i_TargetId);
}
internal static DataTable getIncen(TargetEntryBO TarentBO)
{
BsfGlobal.OpenCRMDB();
string ssql = "";
DataTable dtTarReg = null;
SqlDataAdapter da = null;
try
{
ssql = String.Format("Select * from IncentiveTrans Where TargetId={0}", TarentBO.i_TargetId);
da = new SqlDataAdapter(ssql, BsfGlobal.g_CRMDB);
dtTarReg = new DataTable();
da.Fill(dtTarReg);
}
catch (Exception e)
{
BsfGlobal.CustomException(e.Message, e.StackTrace);
}
finally
{
BsfGlobal.g_CRMDB.Close();
}
return(dtTarReg);
}
public static void InsertIncentiveTrans(string s_Mode, DataTable dt, TargetEntryBO TargetBO)
{
TargetEntryDL.InsertIncentiveTrans(s_Mode, dt, TargetBO);
}
public static void InsertTargetTrans(string s_Mode, TargetEntryBO TarEntBO)
{
TargetEntryDL.InsertTargetTrans(s_Mode, TarEntBO);
}
public static int InsertTargetMaster(string s_Mode, TargetEntryBO TarEntBO)
{
return(TargetEntryDL.InsertTargetMaster(s_Mode, TarEntBO));
}
public static DataTable getEditIncentiveTran(TargetEntryBO TargetBO)
{
return(TargetRegDL.getEditIncentiveTran(TargetBO));
}
public static DataTable getEditTarTrans(TargetEntryBO TargetBO)
{
return(TargetRegDL.getEditTarTrans(TargetBO));
}
