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";
}
}
private void InsUpdDelCompanyInfo(char Event, string Id)
{
try
{
BL_CompanyInfoDrose obj = new BL_CompanyInfoDrose();
string CompanyName = txtCompanyName.Text;
string CompanyName1 = CompanyName.Substring(0, 10);
int cc = CompanyName.Length - 10;
string CompanyName2 = CompanyName.Substring(10, cc);
obj.EVENT = Event;
obj.Co_ID = 0;
if (Event == 'I' || Event == 'U')
{
obj.CompanyName = txtCompanyName.Text;
obj.RegistrationNo = txtRegistrationNo.Text;
obj.PanNo = (txtPanNo.Text);
obj.Country = (txtCountry.Text);
obj.State = (txtState.Text);
obj.City = (txtCity.Text);
obj.Adress1 = (txtAddress1.Text);
obj.Adress2 = (txtAddress2.Text);
obj.TelephoneNo = (txtTelephoneNo.Text);
obj.EmailAdress = (txtEmailAddress.Text);
obj.WebAdress = (txtWebAddress.Text);
obj.C1 = (CompanyName1);
obj.C2 = (CompanyName2);
obj.MC = "";
obj.Created_Date = (ConvertNE.convertNepaliToEnglish(txtDate.Text).ToString());
obj.COMPANY_CODE = Id;
obj.ADMIN_USER_NAME = (txtUserName.Text);
obj.PWD = (txtPassword.Text);
obj.IMAGES_DRIVE = txtImagesDrive.Text;
obj.CONTACT_PERSON_NAME = txtContactAddress.Text;
obj.EMAIL_ADDRESS = txtEmailAdd.Text;
obj.MIRROR_AC_DROSE = txtMirrorDrose.Text;
obj.MIRROR_AC_NCB = txtMirrorNCB.Text;
obj.NOSTRO_AC_NCB = txtNostroAcNCB.Text;
obj.MOB_NO = txtMobNo.Text;
obj.C_ADDRESS = txtContactAddress.Text;
obj.C_TEL_NO = txtTelNo.Text;
}
string msg = obj.InsUpdDelCompanyInfo(out Id);
if (msg == "Record Inserted Successfully" || msg == "Record Updated Successfully" || msg == "Record Deleted Successfully")
{
string path = txtImagesDrive.Text + Id.ToString();
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
string p = picUpload(FileUpload1, path);
if (p == "url")
{
p = "nophoto.gif";
}
//Check Info In Company Code
// BL_CompanyInfoDrose.
msgbox.ShowSuccess(msg);
Response.Redirect("~/Common/OrganizationList.aspx");
ExecuteQuery(Id);
Clear();
}
else
{
msgbox.ShowWarning(msg);
}
}
catch (Exception ex)
{
msgbox.ShowWarning(ex.Message);
}
}