public virtual CloudAccountDA.FeatureMasterDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; CloudAccountDA.FeatureMasterDataTable dataTable = new CloudAccountDA.FeatureMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual int Fill(CloudAccountDA.FeatureMasterDataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (this.ClearBeforeFill) { dataTable.Clear(); } return(this.Adapter.Fill(dataTable)); }
public Stream ShowProfileImage(int conId) { this._objFeatureMasterDt = this._objFeatureMasterBll.GetDataByFeatureID(conId); try { return((Stream) new MemoryStream((byte[])this._objFeatureMasterDt.Rows[0]["FeatureImage"])); } catch { return((Stream)null); } }
protected void btnUpdate_Click(object sender, EventArgs e) { try { if (this.Page.IsValid) { if (this.txtFeatureName.Text.Trim().Length > 0) { if (this.fuFeatureImage.HasFile) { int contentLength = this.fuFeatureImage.PostedFile.ContentLength; byte[] numArray = new byte[contentLength]; this.fuFeatureImage.PostedFile.InputStream.Read(numArray, 0, contentLength); if (this.objFeatureMasterBll.UpdateFeature(int.Parse(this.hfFeature.Value.Trim()), this.txtFeatureName.Text.Trim(), numArray, this.txtDesc.Text.Trim(), this.chkStatus.Checked, this.chkHome.Checked)) { this.DisplayAlert("Update Successfully.."); this.Response.Redirect("~/BillTransact/FeatureMaster.aspx?cmd=view&ID=" + this.Request.QueryString["ID"]); } else { this.DisplayAlert("Fail to Update Details."); } } else { this.objFeatureMasterDT = this.objFeatureMasterBll.GetDataByFeatureID(int.Parse(this.hfFeature.Value.Trim())); if (this.objFeatureMasterBll.UpdateFeature(int.Parse(this.hfFeature.Value.Trim()), this.txtFeatureName.Text.Trim(), (byte[])this.objFeatureMasterDT.Rows[0]["FeatureImage"], this.txtDesc.Text.Trim(), this.chkStatus.Checked, this.chkHome.Checked)) { this.DisplayAlert("Update Successfully.."); this.Response.Redirect("~/BillTransact/FeatureMaster.aspx?cmd=view&ID=" + this.Request.QueryString["ID"]); } else { this.DisplayAlert("Fail to Update Details."); } } } else { this.DisplayAlert("Please Fill All Details...!"); } } else { this.DisplayAlert("Fail to Update Details."); } } catch (Exception ex) { this.DisplayAlert(ex.Message); } }
protected void gvFeature_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType != DataControlRowType.DataRow) { return; } this.objFeatureMasterDT = this.objFeatureMasterBll.GetDataByFeatureID(int.Parse(e.Row.Cells[1].Text)); if (this.objFeatureMasterDT.Rows.Count == 0) { return; } e.Row.Cells[1].Text = this.objFeatureMasterDT.Rows[0]["FeatureName"].ToString(); }
private void SetRecord(string iD) { this.objFeatureMasterDT = this.objFeatureMasterBll.GetDataByFeatureID(int.Parse(iD)); if (this.objFeatureMasterDT.Rows.Count <= 0) { return; } this.hfFeature.Value = this.objFeatureMasterDT.Rows[0]["FeatureID"].ToString(); this.txtFeatureName.Text = this.objFeatureMasterDT.Rows[0]["FeatureName"].ToString(); this.txtDesc.Text = this.objFeatureMasterDT.Rows[0]["FeatureDesc"].ToString(); this.chkStatus.Checked = this.objFeatureMasterDT.Rows[0]["FeatureStatus"].ToString() == "True"; this.chkHome.Checked = this.objFeatureMasterDT.Rows[0]["ShowOnHomePage"].ToString() == "True"; }
private void ViewRecord(string i) { this.objFeatureMasterDT = this.objFeatureMasterBll.GetDataByFeatureID(int.Parse(i)); if (this.objFeatureMasterDT.Rows.Count <= 0) { return; } this.hfFeature.Value = this.objFeatureMasterDT.Rows[0]["FeatureID"].ToString(); this.lblFeatureName.Text = this.objFeatureMasterDT.Rows[0]["FeatureName"].ToString(); this.lblDesc.Text = this.objFeatureMasterDT.Rows[0]["FeatureDesc"].ToString(); this.lblStatus.Text = this.objFeatureMasterDT.Rows[0]["FeatureStatus"].ToString() == "True" ? "True" : "False"; this.lblHome.Text = this.objFeatureMasterDT.Rows[0]["ShowOnHomePage"].ToString() == "True" ? "True" : "False"; this.imgFeatureImage.ImageUrl = "~/Handler/FeatureHandler.ashx?id=" + this.hfFeature.Value; }
public virtual CloudAccountDA.FeatureMasterDataTable GetDataByFeatureID(int?FeatureID) { this.Adapter.SelectCommand = this.CommandCollection[1]; if (FeatureID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = FeatureID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } CloudAccountDA.FeatureMasterDataTable dataTable = new CloudAccountDA.FeatureMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual CloudAccountDA.FeatureMasterDataTable GetDataByFeatureName(string FeatureName) { this.Adapter.SelectCommand = this.CommandCollection[2]; if (FeatureName == null) { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = FeatureName; } CloudAccountDA.FeatureMasterDataTable dataTable = new CloudAccountDA.FeatureMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
protected void btnSubmit_Click(object sender, EventArgs e) { if (!this.Page.IsValid) { return; } if (this.txtFeatureName.Text.Trim().Length > 0 && this.fuFeatureImage.HasFile) { this.objFeatureMasterDT = this.objFeatureMasterBll.GetDataByFeatureName(this.txtFeatureName.Text); if (this.objFeatureMasterDT.Rows.Count > 0) { this.DisplayAlert("Feature Already Exist.."); FeatureMaster.checkInDB = true; } else { FeatureMaster.checkInDB = false; } if (!FeatureMaster.checkInDB) { int contentLength = this.fuFeatureImage.PostedFile.ContentLength; byte[] numArray = new byte[contentLength]; this.fuFeatureImage.PostedFile.InputStream.Read(numArray, 0, contentLength); int num = this.objFeatureMasterBll.AddFeature(this.txtFeatureName.Text.Trim(), numArray, this.txtDesc.Text.Trim(), this.chkStatus.Checked, this.chkHome.Checked); if (num != 0) { this.DisplayAlert("Details Added Successfully."); this.Response.Redirect("~/BillTransact/FeatureMaster.aspx?cmd=view&ID=" + (object)num); } else { this.DisplayAlert("Fail to Add New Details."); this.Clear(); } } else { this.DisplayAlert("Fail to Add New Details."); this.Clear(); } } else { this.DisplayAlert("Please Fill All Details...!"); } }
public virtual int Update(CloudAccountDA.FeatureMasterDataTable dataTable) { return(this.Adapter.Update(dataTable)); }