void ResetPassword()
{
try
{
ep1.Clear();
if (string.IsNullOrEmpty(cmbUserName.Text.Trim()))
{
ep1.SetError(cmbUserName, "User Name is required.");
cmbUserName.Focus();
return;
}
if (string.IsNullOrEmpty(txtResetPassword.Text.Trim()))
{
ep1.SetError(txtResetPassword, "Reset password is required.");
txtResetPassword.Focus();
return;
}
db = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
TL01_USER tblUser = db.TL01_USERs.Single(TL01_USER => TL01_USER.TL01_USERID.ToString() == cmbUserName.SelectedValue.ToString());
tblUser.TL01_PASSWORD = txtResetPassword.Text.Trim();
db.SubmitChanges();
cmbUserName.SelectedIndex = 0;
txtResetPassword.Text = "";
Datalayer.InformationMessageBox("Password reset sucesfully.");
}
catch (Exception ex)
{
Datalayer.WorningMessageBox(ex.Message.ToString(), "Error");
}
}
void AddUser()
{
try
{
ep1.Clear();
if (string.IsNullOrEmpty(txtOldPassword.Text.Trim()))
{
ep1.SetError(txtOldPassword, "Old Password is requied.");
txtOldPassword.Focus();
return;
}
if (string.IsNullOrEmpty(txtPassword.Text.Trim()))
{
ep1.SetError(txtPassword, "Password is requied.");
txtPassword.Focus();
return;
}
db = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
var lst = (from u in db.TL01_USERs select u).Where(s => s.TL01_USERID == Datalayer.iTL01_USERID).ToList();
if (lst != null && lst.Count > 0)
{
if (lst[0].TL01_PASSWORD.ToString() != txtOldPassword.Text.Trim())
{
Datalayer.InformationMessageBox("Old password is not correct..");
txtOldPassword.Focus();
return;
}
}
db = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
TL01_USER tlUser = new TL01_USER();
tlUser.TL01_PASSWORD = txtPassword.Text.Trim();
tlUser.TL01_ROLE = "User";
db.TL01_USERs.InsertOnSubmit(tlUser);
db.SubmitChanges();
txtPassword.Text = "";
txtPassword.Focus();
Datalayer.InsertMessageBox(sPageName);
}
catch (Exception ex)
{
Datalayer.WorningMessageBox(ex.Message.ToString(), "Error");
}
}
void AddUpdateCompany()
{
try
{
ep1.Clear();
if (string.IsNullOrEmpty(txtName.Text.Trim()))
{
ep1.SetError(txtName, "Name is Required..");
txtName.Focus();
return;
}
FileStream fsStudentPhto;
BinaryReader brStudentPhoto;
if (!string.IsNullOrEmpty(txtPhoto.Text.Trim()))
{
string FileName = txtPhoto.Text.Trim();
fsStudentPhto = new FileStream(FileName, FileMode.Open, FileAccess.Read);
brStudentPhoto = new BinaryReader(fsStudentPhto);
bytStudentPhoto = brStudentPhoto.ReadBytes((int)fsStudentPhto.Length);
brStudentPhoto.Close();
fsStudentPhto.Close();
}
int?Iout = 0;
if (Datalayer.iEditT001_COMPANYID > 0)
{
db = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
TM_COMPANY _TM_COMPANY = db.TM_COMPANies.Single(TM_COMPANY => TM_COMPANY.TM_COMPAYID.ToString() == Datalayer.iEditT001_COMPANYID.ToString());
_TM_COMPANY.TM_NAME = txtName.Text.Trim();
_TM_COMPANY.TM_ADDRESS1 = txtAddress1.Text.Trim();
_TM_COMPANY.TM_PHONENO = txtPhoneNo.Text.Trim();
_TM_COMPANY.TM_EMAIL = txtEmailID.Text.Trim();
_TM_COMPANY.TM_BANK = txtBankName.Text.Trim();
_TM_COMPANY.TM_BRANCH = txtBranch.Text.Trim();
_TM_COMPANY.TM_IFSC = txtIFSCCOde.Text.Trim();
_TM_COMPANY.TM_ACCOUNTNO = txtAccountNo.Text.Trim();
_TM_COMPANY.TM_ACTIVE = chkIsActive.Checked;
_TM_COMPANY.TM_TINNO = txtGSTNo.Text.Trim();
if (bytStudentPhoto != null)
{
_TM_COMPANY.TM_IMAGE = bytStudentPhoto;
}
db.SubmitChanges();
Datalayer.UpdateMessageBox(sPageName);
// Datalayer.InformationMessageBox("Please restart software.");
this.Close();
}
else
{
TM_COMPANY _TM_COMPANY = new TM_COMPANY();
_TM_COMPANY.TM_NAME = txtName.Text.Trim();
_TM_COMPANY.TM_ADDRESS1 = txtAddress1.Text.Trim();
_TM_COMPANY.TM_PHONENO = txtPhoneNo.Text.Trim();
_TM_COMPANY.TM_EMAIL = txtEmailID.Text.Trim();
_TM_COMPANY.TM_BANK = txtBankName.Text.Trim();
_TM_COMPANY.TM_BRANCH = txtBranch.Text.Trim();
_TM_COMPANY.TM_IFSC = txtIFSCCOde.Text.Trim();
_TM_COMPANY.TM_ACCOUNTNO = txtAccountNo.Text.Trim();
_TM_COMPANY.TM_TINNO = txtGSTNo.Text.Trim();
_TM_COMPANY.TM_ACTIVE = chkIsActive.Checked;
if (!string.IsNullOrEmpty(txtPhoto.Text))
{
_TM_COMPANY.TM_IMAGE = bytStudentPhoto;
}
db = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
db.TM_COMPANies.InsertOnSubmit(_TM_COMPANY);
db.SubmitChanges();
Datalayer.InsertMessageBox(sPageName);
}
ResetData();
}
catch (Exception ex)
{
Datalayer.WorningMessageBox(ex.Message.ToString(), "Error");
}
}
