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)); }