public bool SaveUpdate(mdlSalesOpportunity objmdlSalesOpportunity, DataTable dtProductDetail, DataTable dtDocumentList, DataTable dtStages, DataTable dtAttachment, DataTable dtCompetitor, string SaveUpdate) { bool Save = false; SqlTransaction transection; if (conn.State == ConnectionState.Open) { conn.Close(); } conn.Open(); transection = conn.BeginTransaction(); try { cmd = new SqlCommand("stp_ERP_SalesOpportunity_CRUD", conn, transection); cmd.Parameters.Add("@BidValue", SqlDbType.Decimal).Value = Convert.ToDecimal(objmdlSalesOpportunity.BidValue); cmd.Parameters.Add("@ChannelName", SqlDbType.VarChar, 50).Value = objmdlSalesOpportunity.ChannelName; cmd.Parameters.Add("@ClosingPercentage", SqlDbType.Int).Value = Convert.ToInt32(objmdlSalesOpportunity.ClosingPercentage); cmd.Parameters.Add("@Fk_ContactPerson", SqlDbType.VarChar, 6).Value = objmdlSalesOpportunity.ContactPersonId; cmd.Parameters.Add("@Fk_CustomerId", SqlDbType.VarChar, 6).Value = objmdlSalesOpportunity.CustomerId; cmd.Parameters.Add("@DueDate", SqlDbType.Date).Value = objmdlSalesOpportunity.DueDate; cmd.Parameters.Add("@EndDate", SqlDbType.Date).Value = objmdlSalesOpportunity.EndDate; cmd.Parameters.Add("@OpenActivities", SqlDbType.Int).Value = Convert.ToInt32(objmdlSalesOpportunity.OpenActivity); cmd.Parameters.Add("@OpportunityId", SqlDbType.Int).Value = Convert.ToInt32(objmdlSalesOpportunity.OpportunityId); cmd.Parameters.Add("@ApportunityName", SqlDbType.VarChar, 50).Value = objmdlSalesOpportunity.OppertunityName; cmd.Parameters.Add("@PartnerName", SqlDbType.VarChar, 50).Value = objmdlSalesOpportunity.PartnerName; cmd.Parameters.Add("@PotientialAmout", SqlDbType.Decimal).Value = Convert.ToDecimal(objmdlSalesOpportunity.PotientialAmount); cmd.Parameters.Add("@PotientialGP", SqlDbType.VarChar, 50).Value = objmdlSalesOpportunity.potientialGP; cmd.Parameters.Add("@PredictedDate", SqlDbType.Date).Value = objmdlSalesOpportunity.PredictedDate; cmd.Parameters.Add("@PredictedTime", SqlDbType.VarChar, 50).Value = objmdlSalesOpportunity.PredictedTime; cmd.Parameters.Add("@PurValue", SqlDbType.Decimal).Value = Convert.ToDecimal(objmdlSalesOpportunity.PurValue); cmd.Parameters.Add("@Reason", SqlDbType.VarChar, 100).Value = objmdlSalesOpportunity.Reason; cmd.Parameters.Add("@RelationShip", SqlDbType.VarChar, 50).Value = objmdlSalesOpportunity.RelationShip; cmd.Parameters.Add("@Remarks", SqlDbType.VarChar, 100).Value = objmdlSalesOpportunity.Remarks; cmd.Parameters.Add("@Fk_SaleEmployee", SqlDbType.VarChar, 6).Value = objmdlSalesOpportunity.SaleEmployee; cmd.Parameters.Add("@StartDate", SqlDbType.Date).Value = objmdlSalesOpportunity.StartDate; cmd.Parameters.Add("@ApportunityStatus", SqlDbType.VarChar, 10).Value = objmdlSalesOpportunity.Status; cmd.Parameters.Add("@SubmitDate", SqlDbType.Date).Value = objmdlSalesOpportunity.SubmitDate; cmd.Parameters.Add("@TechnicalDate", SqlDbType.Date).Value = objmdlSalesOpportunity.TechnicalDate; cmd.Parameters.Add("@TenderNo", SqlDbType.Int).Value = Convert.ToInt32(objmdlSalesOpportunity.TenderNo); cmd.Parameters.Add("@VenderId", SqlDbType.VarChar, 6).Value = objmdlSalesOpportunity.VenderId; cmd.Parameters.Add("@BusinessType", SqlDbType.VarChar, 50).Value = objmdlSalesOpportunity.BusinessType; cmd.Parameters.Add("@TimeType", SqlDbType.VarChar, 50).Value = objmdlSalesOpportunity.TimeType; cmd.Parameters.Add("@AddUser", SqlDbType.VarChar, 10).Value = objmdlSalesOpportunity.AddUser; if (SaveUpdate == "Save") { cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 30).Value = "Save"; } if (SaveUpdate == "Update") { cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 30).Value = "Update"; } cmd.CommandType = CommandType.StoredProcedure; cmd.ExecuteNonQuery(); if (SaveUpdateProductDetail(SaveUpdate, dtProductDetail, objmdlSalesOpportunity.OpportunityId, transection, conn) && SaveUpdateDocumentList(SaveUpdate, dtDocumentList, objmdlSalesOpportunity.OpportunityId, transection, conn) && SaveUpdateStages(SaveUpdate, dtStages, objmdlSalesOpportunity.OpportunityId, transection, conn) && SaveUpdateAttachment() && SaveUpdateCompetitor(SaveUpdate, dtCompetitor, objmdlSalesOpportunity.OpportunityId, transection, conn)) { transection.Commit(); Save = true; } else { transection.Rollback(); Save = false; } if (conn.State == ConnectionState.Open) { conn.Close(); } } catch (Exception ex) { try { transection.Rollback(); } catch (Exception exx) { MessageBox.Show(exx.Message, "Babar Medicine Company - ERP", MessageBoxButtons.OK, MessageBoxIcon.Error); } Save = false; MessageBox.Show(ex.Message, "Babar Medicine Company - ERP", MessageBoxButtons.OK, MessageBoxIcon.Error); } return Save; }
public bool SaveUpdate(mdlSalesOpportunity objmdlSalesOpportunity, DataTable dtProductDetail, DataTable dtDocumentList, DataTable dtStages, DataTable dtAttachment, DataTable dtCompetitor, string SaveUpdate) { return objdalSalesOpportunity.SaveUpdate(objmdlSalesOpportunity, dtProductDetail, dtDocumentList, dtStages, dtAttachment, dtCompetitor, SaveUpdate); }