public string I_UOrganizationDetails(SqlTransaction objTran, DBLayer objDblayer) { String InsertUpdate = ""; List <SqlParameter> sqlPara = new List <SqlParameter>(); sqlPara.Add(new SqlParameter("@OrgName", txtOrgName.Text.Trim())); sqlPara.Add(new SqlParameter("@DomainId", (ddlDomain.SelectedItem as DomainMaster).DomainId)); if (!String.IsNullOrEmpty(txtState.Text.Trim())) { sqlPara.Add(new SqlParameter("@OrgState", txtState.Text.Trim())); } else { sqlPara.Add(new SqlParameter("@OrgState", DBNull.Value)); } if (!String.IsNullOrEmpty(txtCity.Text.Trim())) { sqlPara.Add(new SqlParameter("@OrgCity", txtCity.Text.Trim())); } else { sqlPara.Add(new SqlParameter("@OrgCity", DBNull.Value)); } if (!String.IsNullOrEmpty(txtOrgAdd.Text.Trim())) { sqlPara.Add(new SqlParameter("@OrgAddress", txtOrgAdd.Text.Trim())); } else { sqlPara.Add(new SqlParameter("@OrgAddress", DBNull.Value)); } if (OrgID <= 0) { sqlPara.Add(new SqlParameter("@userId", ParentForm.objLoginDetails.userId)); sqlPara.Add(new SqlParameter("@CallStatusId", 1)); sqlPara.Add(new SqlParameter("@nextCall", DBNull.Value)); objDblayer.ExecNonQuery(@"insert into OrganaizationDetails(OrgName,OrgState,OrgCity,OrgAddress,DomainId,userId,nextCall,CallStatusId) values(@OrgName,@OrgState,@OrgCity,@OrgAddress,@DomainId,@userId,@nextCall,@CallStatusId)", sqlPara.ToArray(), CommandType.Text, objTran); this.OrgID = Convert.ToInt64(objDblayer.SelectScalar("SELECT IDENT_CURRENT('OrganaizationDetails')", Sqltrn: objTran)); InsertUpdate = "Inserted"; } else { sqlPara.Add(new SqlParameter("@OrganizationId", this.OrgID)); objDblayer.ExecNonQuery(@"update OrganaizationDetails set OrgName = @OrgName, OrgState = @OrgState, OrgCity = @OrgCity, OrgAddress = @OrgAddress, DomainId = @DomainId, nextCall = nextCall, CallStatusId = CallStatusId where OrganizationId = @OrganizationId ", sqlPara.ToArray(), CommandType.Text, objTran); InsertUpdate = "Updated"; } return(InsertUpdate); }
private void btnNextCall_Click(object sender, EventArgs e) { if (validateNextCall()) { DBLayer objDblayer = new DBLayer(); SqlConnection SqlCon = objDblayer.conn; SqlCon.Open(); SqlTransaction objTran = SqlCon.BeginTransaction("SaveNextCall"); Int16 chkSuccess = 0; try { DateTime MyDateTime = ((DateTime)dtpicker.Value).Date.Add(((DateTime)dtTimePicker.Value).TimeOfDay); List <SqlParameter> sqlPara = new List <SqlParameter>(); sqlPara.Add(new SqlParameter("@ContactId", (cmbTalkedwith.SelectedItem as ContactDetails).ContactId)); sqlPara.Add(new SqlParameter("@FeedBack", txtFeedback.Text)); objDblayer.ExecNonQuery(@"insert into ChatHistory(ContactId, TalkedOn, FeedBack) values(@ContactId, GETDATE(), @FeedBack)", sqlPara.ToArray(), CommandType.Text, objTran); sqlPara.Clear(); sqlPara.Add(new SqlParameter("@nextCall", dtpicker.Text + " " + dtTimePicker.Text)); sqlPara.Add(new SqlParameter("@CallStatusId", (cmbStatus.SelectedItem as CallStatusMaster).CallStatusId)); sqlPara.Add(new SqlParameter("@OrganizationId", this.OrgID)); objDblayer.ExecNonQuery(@"update OrganaizationDetails set nextCall = Convert(Datetime, @nextCall, 103), CallStatusId = @CallStatusId where OrganizationId = @OrganizationId", sqlPara.ToArray(), CommandType.Text, objTran); objTran.Commit(); chkSuccess = 1; } catch (Exception ex) { objTran.Rollback(); chkSuccess = 0; } finally { SqlCon.Close(); } if (chkSuccess == 1) { SetInitalLoadData(); } } }
private void btnSaveUpCont_Click(object sender, EventArgs e) { if (ValidateSave()) { DialogResult retResul = MessageBox.Show("Proceed With Save/Update?", "Save/Update Confirmation", MessageBoxButtons.YesNo); if (DialogResult.Yes == retResul) { String InsertUpdate = ""; DBLayer objDblayer = new DBLayer(); SqlConnection SqlCon = objDblayer.conn; SqlCon.Open(); SqlTransaction objTran = SqlCon.BeginTransaction("AddContact"); Int16 chkSuccess = 0; try { InsertUpdate = I_UOrganizationDetails(objTran, objDblayer); I_UContactDetails(objTran, objDblayer); objTran.Commit(); chkSuccess = 1; } catch (Exception ex) { objTran.Rollback(); chkSuccess = 0; } finally { SqlCon.Close(); if (InsertUpdate.ToLower() == "inserted") { this.OrgID = 0; resetControl(); } } if (chkSuccess == 1) { SetInitalLoadData(); MessageBox.Show("Save/Update successfully"); } } } }
private void BindGrid(int pageIndex) { try { DBLayer objDblayer = new DBLayer(); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@userId", ParentForm.objLoginDetails.userId), new SqlParameter("@IsTodayWork", IsToday), new SqlParameter("@PageIndex", pageIndex), new SqlParameter("@PageSize", PageSize), new SqlParameter("@RecordCount", SqlDbType.Int, 4), }; Dictionary <String, String> opPara = new Dictionary <string, string>(); opPara.Add("@RecordCount", "0"); DataSet ds = new DataSet(); ds = objDblayer.GetDataSetWithOutParameter("ContactList", para, ref opPara, CommandType.StoredProcedure); if (ds != null && ds.Tables.Count > 0) { /*LstOrgDetail = new List<OrganaizationDetails>(); * foreach (DataRow dr in ds.Tables[0].Rows) * { * LstOrgDetail.Add(new OrganaizationDetails { * OrgName = Convert.ToString(dr["OrgName"]), * OrgCity = Convert.ToString(dr["OrgCity"]), * DomainName = Convert.ToString(dr["DomainName"]), * CallStatusName = Convert.ToString(dr["CallStatusName"]), * }); * }*/ grdContactList.AutoGenerateColumns = false; grdContactList.DataSource = ds.Tables[0]; int recordCount = Convert.ToInt32(opPara["@RecordCount"]); this.PopulatePager(recordCount, pageIndex); } } catch (Exception ex) { } }
private void SetInitalLoadData() { try { cmbTalkedwith.Items.Clear(); cmbTalkedwith.ValueMember = "ContactId"; cmbTalkedwith.DisplayMember = "CntName"; cmbTalkedwith.Items.Add(new ContactDetails { ContactId = 0, CntName = "--Select--" }); cmbTalkedwith.SelectedIndex = 0; DBLayer objDblayer = new DBLayer(); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@OrganisaztionId", OrgID) }; DataSet ds = new DataSet(); ds = objDblayer.getDataSet("GetAddEditContact", para, CommandType.StoredProcedure); if (ds != null && ds.Tables.Count > 0) { if (ds.Tables.Contains("Table")) { // Empty Contact obj } if (ds.Tables.Contains("Table1")) { // contact grid position dropdown. PostionMaster objPosMaster; _PositionLst = new List <PostionMaster>(); _PositionLst.Add(new PostionMaster { PositionId = 0, PositionName = "--Select--" }); foreach (DataRow dr in ds.Tables[1].Rows) { if (!String.IsNullOrEmpty(Convert.ToString(dr["PositionId"])) && !String.IsNullOrEmpty(Convert.ToString(dr["PositionName"]))) { objPosMaster = new PostionMaster(); objPosMaster.PositionId = Convert.ToInt64(dr["PositionId"]); objPosMaster.PositionName = Convert.ToString(dr["PositionName"]); _PositionLst.Add(objPosMaster); } } } ddlDomain.Items.Clear(); ddlDomain.DisplayMember = "DomainName"; ddlDomain.ValueMember = "DomainId"; ddlDomain.Items.Insert(0, new DomainMaster { DomainId = 0, DomainName = "--Select--" }); if (ds.Tables.Contains("Table2") && ds.Tables[2].Rows.Count > 0) { //Company Domain //ddlDomain.DataSource = ds.Tables[2]; foreach (DataRow dr in ds.Tables[2].Rows) { ddlDomain.Items.Add(new DomainMaster { DomainId = Convert.ToInt64(dr["DomainId"]), DomainName = Convert.ToString(dr["DomainName"]) }); } } ddlDomain.SelectedIndex = 0; if (ds.Tables.Contains("Table3") && ds.Tables[3].Rows.Count > 0) { txtOrgName.Text = Convert.ToString(ds.Tables[3].Rows[0]["OrgName"]); txtState.Text = Convert.ToString(ds.Tables[3].Rows[0]["OrgState"]); txtCity.Text = Convert.ToString(ds.Tables[3].Rows[0]["OrgCity"]); txtOrgAdd.Text = Convert.ToString(ds.Tables[3].Rows[0]["OrgAddress"]); //if (ddlDomain.ValueMember.Any(x => x.Equals(Convert.ToString(ds.Tables[3].Rows[0]["DomainId"])))) { ddlDomain.SelectedIndex = ddlDomain.FindString(Convert.ToString(ds.Tables[3].Rows[0]["DomainName"])); } } DataGridViewComboBoxColumn objDgvCombobox = (Grdcont.Columns[2] as DataGridViewComboBoxColumn); objDgvCombobox.DataSource = _PositionLst; objDgvCombobox.DisplayMember = "PositionName"; objDgvCombobox.ValueMember = "PositionId"; objDgvCombobox.DataPropertyName = "PositionId"; objDgvCombobox.ValueType = typeof(Int32); _contactDetails = new List <ContactDetails>(); ContactDetails objCntDtail; if (ds.Tables.Contains("Table4") && ds.Tables[4].Rows.Count > 0) { //Grdcont.DataSource = ds.Tables[4]; //(Grdcont.Columns[2] as DataGridViewCheckBoxColumn).DataPropertyName = "" foreach (DataRow dr in ds.Tables[4].Rows) { objCntDtail = new ContactDetails(); objCntDtail.CntName = Convert.ToString(dr["CntName"]); objCntDtail.ContactId = Convert.ToInt64(dr["ContactId"]); objCntDtail.ContNumber = Convert.ToString(dr["ContNumber"]); objCntDtail.EmailId = Convert.ToString(dr["EmailId"]); objCntDtail.InAction = Convert.ToBoolean(dr["InAction"]); objCntDtail.OrganizationId = this.OrgID; objCntDtail.PositionId = Convert.ToInt64(dr["PositionId"]); _contactDetails.Add(objCntDtail); cmbTalkedwith.Items.Add(new ContactDetails { ContactId = objCntDtail.ContactId, CntName = objCntDtail.CntName }); } } for (int i = ds.Tables[4].Rows.Count; i < 20; i++) { objCntDtail = new ContactDetails(); objCntDtail.CntName = ""; objCntDtail.ContactId = 0; objCntDtail.ContNumber = ""; objCntDtail.EmailId = ""; objCntDtail.InAction = false; objCntDtail.OrganizationId = 0; objCntDtail.PositionId = 0; _contactDetails.Add(objCntDtail); } Grdcont.AutoGenerateColumns = false; Grdcont.DataSource = _contactDetails; //bind chat history _ChatHistory = new List <ChatHistory>(); ChatHistory objChtHtr; grdChatHistory.AutoGenerateColumns = false; if (ds.Tables.Contains("Table5") && ds.Tables[5].Rows.Count > 0) { grdChatHistory.DataSource = ds.Tables[5]; //objChtHtr = new ChatHistory(); } grdChatHistory.DataSource = ds.Tables[5]; List <CallStatusMaster> _CallStatus = new List <CallStatusMaster>(); if (ds.Tables.Contains("Table6") && ds.Tables[6].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[6].Rows) { if (Convert.ToInt32(dr["CallStatusId"]) != 1) { _CallStatus.Add(new CallStatusMaster { CallStatusId = Convert.ToInt32(dr["CallStatusId"]), CallStatusName = Convert.ToString(dr["CallStatusName"]) }); } } } cmbStatus.DisplayMember = "CallStatusName"; cmbStatus.ValueMember = "CallStatusId"; cmbStatus.DataSource = _CallStatus; }//end of dataset. this.dtTimePicker.CustomFormat = "hh:mm tt"; this.dtTimePicker.Format = System.Windows.Forms.DateTimePickerFormat.Custom; this.dtTimePicker.ShowUpDown = true; this.dtpicker.MinDate = DateTime.Now; //Readonly logic for appointment fields. dtpicker.Enabled = true; dtTimePicker.Enabled = true; cmbTalkedwith.Enabled = true; cmbStatus.Enabled = true; txtFeedback.Enabled = true; btnNextCall.Visible = true; if (OrgID <= 0) { dtpicker.Enabled = false; dtTimePicker.Enabled = false; cmbTalkedwith.Enabled = false; cmbStatus.Enabled = false; txtFeedback.Enabled = false; btnNextCall.Visible = false; } } catch (Exception ex) { } }
public void I_UContactDetails(SqlTransaction objTran, DBLayer objDblayer) { Int64 RtCntDetId = 0; List <SqlParameter> sqlPara; ContactDetails cntDetails; foreach (DataGridViewRow dgvRow in Grdcont.Rows) { cntDetails = ((ContactDetails)dgvRow.DataBoundItem); if (!String.IsNullOrEmpty(cntDetails.CntName.Trim())) { sqlPara = new List <SqlParameter>(); if (cntDetails.PositionId > 0) { sqlPara.Add(new SqlParameter("@PositionId", cntDetails.PositionId)); } else { sqlPara.Add(new SqlParameter("@PositionId", DBNull.Value)); } if (!String.IsNullOrEmpty(cntDetails.CntName.Trim())) { sqlPara.Add(new SqlParameter("@CntName", cntDetails.CntName)); } else { sqlPara.Add(new SqlParameter("@CntName", DBNull.Value)); } if (!String.IsNullOrEmpty(cntDetails.EmailId.Trim())) { sqlPara.Add(new SqlParameter("@EmailId", cntDetails.EmailId)); } else { sqlPara.Add(new SqlParameter("@EmailId", DBNull.Value)); } if (!String.IsNullOrEmpty(cntDetails.ContNumber.Trim())) { sqlPara.Add(new SqlParameter("@ContNumber", cntDetails.ContNumber)); } else { sqlPara.Add(new SqlParameter("@ContNumber", DBNull.Value)); } sqlPara.Add(new SqlParameter("@InAction", cntDetails.InAction)); if (cntDetails.ContactId <= 0) { sqlPara.Add(new SqlParameter("@OrganizationId", this.OrgID)); objDblayer.ExecNonQuery(@"insert into ContactDetails(OrganizationId, CntName, PositionId,EmailId,ContNumber, InAction) values(@OrganizationId, @CntName, @PositionId, @EmailId, @ContNumber, @InAction)", sqlPara.ToArray(), CommandType.Text, objTran); } if (cntDetails.ContactId > 0) { sqlPara.Add(new SqlParameter("@ContactId", cntDetails.ContactId)); objDblayer.ExecNonQuery(@"update ContactDetails set CntName = @CntName, PositionId = @PositionId, EmailId = @EmailId, ContNumber = @ContNumber, InAction = @InAction where ContactId = @ContactId", sqlPara.ToArray(), CommandType.Text, objTran); } } } }