private void FillgvCompanySearch() { DataTable dt = BL_CompanyInfoDrose.GetCompanyInfo(3, txtCompanyName.Text, txtCompanyCode.Text, System.DateTime.Now); gvCompany.DataSource = dt; gvCompany.DataBind(); }
private void FillgvCompany() { DataTable dt = BL_CompanyInfoDrose.GetCompanyInfo(2, "", "", System.DateTime.Now); gvCompany.DataSource = dt; gvCompany.DataBind(); }
protected void gvCompany_PageIndexChanging(object sender, GridViewPageEventArgs e) { DataTable dt = BL_CompanyInfoDrose.GetCompanyInfo(2, "", "", System.DateTime.Now); gvCompany.DataSource = dt; gvCompany.PageIndex = e.NewPageIndex; gvCompany.DataBind(); }
//public static string (string stringToEncrypt)// Encrypt the content //{ // byte[] key; // byte[] IV; // byte[] inputByteArray; // try // { // key = Convert2ByteArray(DESKey); // IV = Convert2ByteArray(DESIV); // inputByteArray = Encoding.UTF8.GetBytes(stringToEncrypt); // DESCryptoServiceProvider des = new DESCryptoServiceProvider(); // MemoryStream ms = new MemoryStream(); CryptoStream cs = new CryptoStream(ms, des.CreateEncryptor(key, IV), CryptoStreamMode.Write); // cs.Write(inputByteArray, 0, inputByteArray.Length); // cs.FlushFinalBlock(); // return Convert.ToBase64String(ms.ToArray()); // } // catch (System.Exception ex) // { // throw ex; // } //} //static byte[] Convert2ByteArray(string strInput) //{ // int intCounter; char[] arrChar; // arrChar = strInput.ToCharArray(); // byte[] arrByte = new byte[arrChar.Length]; // for (intCounter = 0; intCounter <= arrByte.Length - 1; intCounter++) // arrByte[intCounter] = Convert.ToByte(arrChar[intCounter]); // return arrByte; //} private void GetCompanyInfo(string CompanyCode) { DataTable dt = BL_CompanyInfoDrose.GetCompanyInfo(1, "", CompanyCode, System.DateTime.Now); if (dt.Rows.Count > 0) { txtCompanyName.Text = dt.Rows[0]["CompanyName"].ToString(); txtRegistrationNo.Text = ""; txtRegistrationNo.Enabled = false; txtPanNo.Text = (dt.Rows[0]["PanNo"].ToString()); txtCountry.Text = (dt.Rows[0]["Country"].ToString()); txtState.Text = (dt.Rows[0]["State"].ToString()); txtCity.Text = (dt.Rows[0]["City"].ToString()); txtAddress1.Text = (dt.Rows[0]["Adress1"].ToString()); txtAddress2.Text = (dt.Rows[0]["Adress2"].ToString()); txtTelephoneNo.Text = (dt.Rows[0]["TelephoneNo"].ToString()); // (dt.Rows[0]["Logo"].ToString()); txtEmailAddress.Text = (dt.Rows[0]["EmailAdress"].ToString()); txtWebAddress.Text = (dt.Rows[0]["WebAdress"].ToString()); //(dt.Rows[0]["C1"].ToString()); //(dt.Rows[0]["C2"].ToString()); // (dt.Rows[0]["MC"].ToString()); txtDate.Text = ConvertNE.ConvertEToNWithSlash(Convert.ToDateTime((dt.Rows[0]["Created_Date"].ToString()))); btn_insert.CommandArgument = dt.Rows[0]["COMPANY_CODE"].ToString(); // (dt.Rows[0]["DATABASE_NAME"].ToString()); txtUserName.Text = (dt.Rows[0]["ADMIN_USER_NAME"].ToString()); //(dt.Rows[0]["PWD"].ToString()); txtImagesDrive.Text = dt.Rows[0]["IMAGES_DRIVE"].ToString(); txtContactPersonName.Text = dt.Rows[0]["CONTACT_PERSON_NAME"].ToString(); txtTelNo.Text = dt.Rows[0]["C_TEL_NO"].ToString(); txtMobNo.Text = dt.Rows[0]["MOB_NO"].ToString(); txtContactAddress.Text = dt.Rows[0]["C_ADDRESS"].ToString(); txtEmailAdd.Text = dt.Rows[0]["EMAIL_ADDRESS"].ToString(); txtNostroAcNCB.Text = dt.Rows[0]["NOSTRO_AC_NCB"].ToString(); txtMirrorNCB.Text = dt.Rows[0]["MIRROR_AC_NCB"].ToString(); txtMirrorNCB.Text = dt.Rows[0]["MIRROR_AC_DROSE"].ToString(); btn_insert.Text = "Update"; btn_insert.CommandName = "Update"; } }