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)); }