public virtual CloudAccountDA.ContractorMasterDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; CloudAccountDA.ContractorMasterDataTable dataTable = new CloudAccountDA.ContractorMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
protected void txtEmail_OnTextChanged(object sender, EventArgs e) { this.objCompanyClientContactDetailDT = this.objCompanyClientContactDetailBll.GetDataByCompanyEmail(int.Parse(this.hfCompanyID.Value), this.txtEmail.Text.Trim()); this.objStaffMasterDT = this.objStaffMasterBll.GetDataByCompanyEmail(int.Parse(this.hfCompanyID.Value), this.txtEmail.Text.Trim()); this.objContractorMasterDT = this.objContractorMasterBll.GetDataByCompanyEmail(int.Parse(this.hfCompanyID.Value), this.txtEmail.Text.Trim()); if (this.objCompanyClientContactDetailDT.Rows.Count > 0) { ScriptManager.RegisterClientScriptBlock(sender as Control, this.GetType(), "alert", "alert('Email Already Register With System To Some Client.')", true); this.txtEmail.Text = ""; this.txtEmail.Focus(); } else if (this.objStaffMasterDT.Rows.Count > 0) { ScriptManager.RegisterClientScriptBlock(sender as Control, this.GetType(), "alert", "alert('Email Already Register With System To Some Staff.')", true); this.txtEmail.Text = ""; this.txtEmail.Focus(); } else if (this.objContractorMasterDT.Rows.Count > 0) { ScriptManager.RegisterClientScriptBlock(sender as Control, this.GetType(), "alert", "alert('Email Already Register With System To Some Contractor.')", true); this.txtEmail.Text = ""; this.txtEmail.Focus(); } else { this.txtFirstName.Focus(); } }
public virtual CloudAccountDA.ContractorMasterDataTable UpdateWhenDelete(int?ContractorID, bool?Active, bool?Deleted) { this.Adapter.SelectCommand = this.CommandCollection[6]; if (ContractorID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = ContractorID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } if (Active.HasValue) { this.Adapter.SelectCommand.Parameters[2].Value = Active.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value; } if (Deleted.HasValue) { this.Adapter.SelectCommand.Parameters[3].Value = Deleted.Value; } else { this.Adapter.SelectCommand.Parameters[3].Value = DBNull.Value; } CloudAccountDA.ContractorMasterDataTable dataTable = new CloudAccountDA.ContractorMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual int Fill(CloudAccountDA.ContractorMasterDataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (this.ClearBeforeFill) { dataTable.Clear(); } return(this.Adapter.Fill(dataTable)); }
private bool CheckEmail(string email) { this.objCompanyClientContactDetailDT = this.objCompanyClientContactDetailBll.GetDataByCompanyEmail(int.Parse(this.hfCompanyID.Value), email.Trim()); this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyEmail(int.Parse(this.hfCompanyID.Value), email.Trim()); this.objStaffMasterDT = this.objStaffMasterBll.GetDataByCompanyEmail(int.Parse(this.hfCompanyID.Value), email.Trim()); this.objContractorMasterDT = this.objContractorMasterBll.GetDataByCompanyEmail(int.Parse(this.hfCompanyID.Value), email.Trim()); this.objCompanyMasterDT = this.objCompanyMasterBll.GetDataByCompanyEmail(email.Trim()); if (this.objCompanyMasterDT.Rows.Count > 0) { return(this.hfCompanyID.Value == this.objCompanyMasterDT.Rows[0]["CompanyID"].ToString() ? true : true); } return(this.objCompanyClientMasterDT.Rows.Count > 0 || this.objCompanyClientContactDetailDT.Rows.Count > 0 || (this.objStaffMasterDT.Rows.Count > 0 || this.objContractorMasterDT.Rows.Count > 0)); }
public virtual CloudAccountDA.ContractorMasterDataTable DeleteByCompanyID(int?CompanyID) { this.Adapter.SelectCommand = this.CommandCollection[1]; if (CompanyID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = CompanyID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } CloudAccountDA.ContractorMasterDataTable dataTable = new CloudAccountDA.ContractorMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
private void ViewRecord(string iD) { this.objContractorMasterDT = this.objContractorMasterBll.GetDataByContractorID(int.Parse(iD)); if (this.objContractorMasterDT.Rows.Count <= 0) { return; } this.hfContractorID.Value = this.objContractorMasterDT.Rows[0]["ContractorID"].ToString(); this.hfCompanyID.Value = this.objContractorMasterDT.Rows[0]["CompanyID"].ToString(); this.lblContractorName1.Text = this.lblContractorName.Text = this.objContractorMasterDT.Rows[0]["ContractorName"].ToString(); this.lblContractorEmail.Text = this.objContractorMasterDT.Rows[0]["ContractorEmail"].ToString(); this.lblRebillRate.Text = this.objContractorMasterDT.Rows[0]["RebillRate"].ToString(); string s = this.objContractorMasterDT.Rows[0]["TaskID"].ToString(); if (string.IsNullOrEmpty(s)) { return; } this.objTaskMasterDT = this.objTaskMasterBll.GetDataByTaskID(int.Parse(s)); this.lblTask.Text = this.objTaskMasterDT.Rows[0]["TaskName"].ToString(); }
private void SetRecord(string iD) { this.objContractorMasterDT = this.objContractorMasterBll.GetDataByContractorID(int.Parse(iD)); if (this.objContractorMasterDT.Rows.Count <= 0) { return; } this.hfContractorID.Value = this.objContractorMasterDT.Rows[0]["ContractorID"].ToString(); this.hfCompanyID.Value = this.objContractorMasterDT.Rows[0]["CompanyID"].ToString(); this.txtContractorName.Text = this.objContractorMasterDT.Rows[0]["ContractorName"].ToString(); this.txtContractorEmail.Text = this.objContractorMasterDT.Rows[0]["ContractorEmail"].ToString(); this.txtRebillRate.Text = this.objContractorMasterDT.Rows[0]["RebillRate"].ToString(); string str1 = this.objContractorMasterDT.Rows[0]["TaskID"].ToString(); if (!string.IsNullOrEmpty(str1)) { this.ddlTask.SelectedValue = str1; } this.sqldsProjects.DataBind(); this.chkProjects.DataBind(); this.projectsDiv.Visible = this.chkProjects.Items.Count > 0; this.objContractorProjectDetailDT = this.objContractorProjectDetailBll.GetDataByContractorID(int.Parse(this.hfContractorID.Value)); if (this.objContractorProjectDetailDT.Rows.Count <= 0) { return; } for (int index = 0; index < this.objContractorProjectDetailDT.Rows.Count; ++index) { string str2 = this.objContractorProjectDetailDT.Rows[index]["ProjectID"].ToString(); foreach (ListItem listItem in this.chkProjects.Items) { if (listItem.Value == str2) { listItem.Selected = true; break; } } } }
public virtual CloudAccountDA.ContractorMasterDataTable GetDataByCompanyIDAndEmail(int?CompanyID, string Email) { this.Adapter.SelectCommand = this.CommandCollection[3]; if (CompanyID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = CompanyID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } if (Email == null) { this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = Email; } CloudAccountDA.ContractorMasterDataTable dataTable = new CloudAccountDA.ContractorMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual int Update(CloudAccountDA.ContractorMasterDataTable dataTable) { return(this.Adapter.Update(dataTable)); }