public int CheckCashAccount()
{
SqlDataReader SqlDtr = null;
int f1 = 0;
dbobj.SelectQuery("select Ledger_ID from Ledger_Master lm, Ledger_Master_sub_grp lmsg where lm.sub_grp_id = lmsg.sub_grp_id and lmsg.sub_grp_name = 'Cash in hand'", ref SqlDtr);
if (SqlDtr.HasRows)
{
f1 = 1;
}
SqlDtr.Close();
return(f1);
}
public IHttpActionResult GetCount(string Customer)
{
SqlDataReader rdr = null;
int Count = 0;
dbobj.SelectQuery("select count(*) from AccountsLedgerTable where Ledger_ID='" + Customer + "'", ref rdr);
if (rdr.Read())
{
Count = int.Parse(rdr.GetValue(0).ToString());
}
return(Ok(Count));
}
public string GetUserID(string loginName)
{
SqlDataReader SqlDtr = null;
string UserId = "";
dbobj.SelectQuery("Select UserID from user_master where loginname='" + loginName + "'", ref SqlDtr);
if (SqlDtr.Read())
{
UserId = SqlDtr.GetValue(0).ToString().Trim();
}
SqlDtr.Close();
return(UserId);
}
public List <string> GetUsers()
{
DbOperations_LATEST.DBUtil obj = new DbOperations_LATEST.DBUtil();
SqlDataReader SqlDtr = null;
List <string> Users = new List <string>();
obj.SelectQuery("select UserID from User_Master", ref SqlDtr);
while (SqlDtr.Read())
{
Users.Add(SqlDtr.GetValue(0).ToString());
}
SqlDtr.Close();
return(Users);
}
public UserModels GetSelectedUser(string userID)
{
DbOperations_LATEST.DBUtil obj = new DbOperations_LATEST.DBUtil();
SqlDataReader SqlDtr = null;
UserModels user = new UserModels();
obj.SelectQuery("select loginname, password, username,role_name from user_master um, roles r where um.role_id=r.role_id and UserId='" + userID + "'", ref SqlDtr);
while (SqlDtr.Read())
{
user.LoginName = SqlDtr.GetValue(0).ToString();
user.Password = SqlDtr.GetValue(1).ToString();
user.UserName = SqlDtr.GetValue(2).ToString();
user.RoleName = SqlDtr.GetValue(3).ToString();
}
SqlDtr.Close();
return(user);
}
public IHttpActionResult SelectLedgerId(string evalue)
{
SqlDataReader SqlDtr = null;
string Ledger_ID = "";
dbobj.SelectQuery("Select Ledger_ID from Ledger_Master where Ledger_Name ='" + evalue + "'", ref SqlDtr);
if (SqlDtr.Read())
{
Ledger_ID = SqlDtr["Ledger_ID"].ToString();
}
SqlDtr.Close();
if (Ledger_ID == "" || Ledger_ID == null)
{
return(Content(HttpStatusCode.NotFound, "Data Not Found"));
}
return(Ok(Ledger_ID));
}
