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