/// <summary>
/// This method is not used.
/// </summary>
private bool IsExpired()
{
int x = 0;
bool Status = false;
dbobj.ExecuteScalar("select count(*) from SysTable", ref x);
if (x <= 0)
{
dbobj.Insert_or_Update("insert into SysTable(SysDate1,SysDate2,allow) values(getdate(),dateadd(dd,30,getdate()),'f')", ref x);
}
else
{
dbobj.Insert_or_Update("if((select SysDate2 from SysTable)<(select getdate())) update SysTable set allow='n'", ref x);
}
System.Data.SqlClient.SqlDataReader rdr = null;
dbobj.SelectQuery("select allow from SysTable", ref rdr);
if (rdr.Read())
{
if (rdr["allow"].Equals("n"))
{
Status = true;
}
}
return(Status);
}
/// <summary>
/// This method is used to delete the particular record from user master table.
/// </summary>
protected void btnDelete_Click(object sender, System.EventArgs e)
{
if (dropUserID.SelectedIndex == 0)
{
RMG.MessageBox.Show("Please select the User ID");
return;
}
int output = 0;
try
{
DBOperations.DBUtil obj = new DBOperations.DBUtil();
obj.Insert_or_Update("delete from User_Master where UserID='" + dropUserID.SelectedItem.Value + "'", ref output);
obj.Insert_or_Update("delete from privileges where User_ID='" + dropUserID.SelectedItem.Value + "'", ref output);
dropUserID.Items.Remove(dropUserID.SelectedItem.Value);
MessageBox.Show("User Deleted");
Clear();
GetNextUserID();
lblUserID.Visible = true;
btnEdit.Visible = true;
dropUserID.Visible = false;
}
catch (Exception ex)
{
CreateLogFiles.ErrorLog("Form:User_Profile.aspx,Method:btnDelete_Click EXCEPTION: " + ex.Message + " " + uid);
}
}
/// <summary>
/// This method is used to save or update the customer according to ssr in customer table.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, System.EventArgs e)
{
try
{
InventoryClass obj = new InventoryClass();
SqlDataReader SqlDtr = null;
int x = 0;
string EmpID = "";
string sql = "select Emp_ID from Employee where Emp_Name='" + DropSSRName.SelectedItem.Text + "'";
SqlDtr = obj.GetRecordSet(sql);
if (SqlDtr.Read())
{
EmpID = SqlDtr["Emp_ID"].ToString();
}
SqlDtr.Close();
for (int i = 0; i < ListassignCustomer.Items.Count; ++i)
{
ListassignCustomer.SelectedIndex = i;
string pname = ListassignCustomer.SelectedItem.Value;
dbobj.Insert_or_Update("update Customer set ssr='" + EmpID + "' where Cust_Name='" + pname + "'", ref x);
}
MessageBox.Show("Customer Mapping Update");
FillList();
DropSSRName.SelectedIndex = 0;
ListassignCustomer.Items.Clear();
CreateLogFiles.ErrorLog("Form:CustomerMapping.aspx,Method:btnSubmit_Click, Update Customer Mapping, User " + uid);
}
catch (Exception ex)
{
CreateLogFiles.ErrorLog("Form:CustomerMapping.aspx,Method:btnSubmit_Click EXCEPTION " + ex.Message + " User " + uid);
}
}
public void DeleteTheRec()
{
try
{
string ledgname1 = "";
ledgname1 = dropLedgerName.SelectedItem.Text.ToString();
string[] strArr = ledgname1.Split(new char[] { ':' }, ledgname1.Length);
SqlDataReader SqlDtr = null;
string id1 = "";
string id2 = "";
// Check if the Voucher Transaction of the selected Ledger to delete is present or not.
dbobj.SelectQuery("Select Ledg_ID_Cr, Ledg_ID_Dr from Voucher_Transaction where Ledg_ID_Cr = " + strArr[1].Trim() + " or Ledg_ID_Dr = " + strArr[1].Trim(), ref SqlDtr);
while (SqlDtr.Read())
{
id1 = SqlDtr["Ledg_ID_Cr"].ToString();
id2 = SqlDtr["Ledg_ID_Dr"].ToString();
}
SqlDtr.Close();
if (!id1.Trim().Equals("") || !id2.Trim().Equals(""))
{
MessageBox.Show("Unable to delete Ledger ");
fetchGroup();
return;
}
else
{
int c = 0, Count = 0;
string subgrpid = "";
dbobj.SelectQuery("select sub_grp_Id from Ledger_Master where Ledger_id = " + strArr[1].Trim(), ref SqlDtr);
while (SqlDtr.Read())
{
subgrpid = SqlDtr["sub_grp_ID"].ToString();
}
SqlDtr.Close();
dbobj.ExecuteScalar("select count(*) from AccountsLedgerTable where Ledger_id = '" + strArr[1].Trim() + "' and particulars<>'Opening balance'", ref Count);
if (Count > 0)
{
MessageBox.Show("Please Remove The All Transaction Concerning Ledger");
return;
}
dbobj.Insert_or_Update("delete from Ledger_master where Ledger_Id = " + strArr[1].Trim(), ref c);
object op = null;
dbobj.ExecProc(OprType.Update, "ProUpdatesubgroup", ref op, "@subgrp_id", subgrpid);
}
MessageBox.Show("Ledger Deleted");
CreateLogFiles.ErrorLog("Form:Ledger Creation,Method:btnDelete_Click Ledger ID " + strArr[1].Trim() + " Deleted. User: "******"Form:Ledger Creation,Method:btnDelete_Click Exception: " + ex.Message + " User: " + uid);
}
}
/// <summary>
/// This method is used to delete the particular Role ID from roles table which role id select from
/// dropdownlist on edit time.
/// </summary>
protected void btnDelete_Click(object sender, System.EventArgs e)
{
try
{
if (dropRoleID.SelectedIndex == 0)
{
RMG.MessageBox.Show("Please select the Role ID");
return;
}
int output = 0;
DBOperations.DBUtil obj = new DBOperations.DBUtil();
obj.ExecuteScalar("select count(*) from User_master where Role_ID='" + dropRoleID.SelectedItem.Value + "'", ref output);
if (output > 0)
{
MessageBox.Show("Selected Role cannot be Deleted");
return;
}
else
{
obj.Insert_or_Update("delete from roles where Role_Id='" + dropRoleID.SelectedItem.Value + "'", ref output);
dropRoleID.Items.Remove(dropRoleID.SelectedItem.Value);
MessageBox.Show("Role Deleted");
CreateLogFiles.ErrorLog("Form:Roles.aspx,Method: btnDelete_Click" + uid);
Clear();
lblRoleID.Visible = true;
dropRoleID.Visible = false;
btnEdit.Visible = true;
btnUpdate.Text = "Save";
GetNextRoleID();
dropRoleID.SelectedIndex = 0;
}
}
catch (Exception ex)
{
MessageBox.Show("Please select Role ID");
CreateLogFiles.ErrorLog("Form:Roles.aspx,Method:btnDelete_Click" + ex.Message + " EXCEPTION " + uid);
}
}