public int InsertOpportunity(OpportunityBO argObject)
{
int identity = 0;
try
{
SqlCommand cmd;
string ReqDate = string.Format("{0:dd/MMM/yyyy}", argObject.ReqDate);
string sSql = "Insert Into dbo.OpportunityRequest (RequestNo,RequestDate,ExecutiveId," +
"CCId,OpportunityName,Amount) " +
"Values('" + argObject.ReqNo + "', '" + ReqDate + "'," +
"'" + argObject.ExecutiveId + "', " + argObject.CCId + "," +
"'" + argObject.OppName + "', " + argObject.Amount + ") SELECT SCOPE_IDENTITY();";
BsfGlobal.OpenCRMDB();
cmd = new SqlCommand(sSql, BsfGlobal.g_CRMDB);
identity = int.Parse(cmd.ExecuteScalar().ToString());
cmd.Dispose();
}
catch (Exception e)
{
BsfGlobal.CustomException(e.Message, e.StackTrace);
}
finally
{
BsfGlobal.g_CRMDB.Close();
}
return(identity);
}
public void UpdateOpportunity(OpportunityBO argObject)
{
try
{
SqlCommand cmd;
string oppDate = string.Format("{0:dd/MMM/yyyy}", argObject.ReqDate);
string sSql = "Update dbo.OpportunityRequest Set RequestNo='" + argObject.ReqNo + "',RequestDate='" + oppDate + "',ExecutiveId='" + argObject.ExecutiveId + "'," +
"CCId=" + argObject.CCId + ",OpportunityName='" + argObject.OppName + "',Amount=" + argObject.Amount + " Where RequestId=" + argObject.ReqId + "";
BsfGlobal.OpenCRMDB();
cmd = new SqlCommand(sSql, BsfGlobal.g_CRMDB);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
catch (Exception e)
{
BsfGlobal.CustomException(e.Message, e.StackTrace);
}
finally
{
BsfGlobal.g_CRMDB.Close();
}
}
public void UpdateOpportunity(OpportunityBO argObject)
{
oOppCapDL.UpdateOpportunity(argObject);
}
public int InsertOpportunity(OpportunityBO argObject)
{
return(oOppCapDL.InsertOpportunity(argObject));
}
