public static Tbl_ClientMaster GetUser(long id)
{
using (GSTDB db = new GSTDB())
{
return(db.Tbl_ClientMaster.Where(x => x.ClientID == id).FirstOrDefault());
}
}
public static List <Tbl_ClientMaster> GetAllUsers()
{
using (GSTDB db = new GSTDB())
{
return(db.Tbl_ClientMaster.ToList());
}
}
public static bool CheckLogin(string uname, string pwd, ref Tbl_LoginMaster obj)
{
bool check = false;
using (GSTDB db = new GSTDB())
{
var user = db.Tbl_LoginMaster.Where(x => x.UserName.Equals(uname) && x.Password.Equals(pwd)).FirstOrDefault();
if (user != null)
{
check = true;
obj = user;
}
}
return(check);
}
public static List <Tbl_ReportMaster> GetReportByClientID(long id)
{
List <Tbl_ReportMaster> list = new List <Tbl_ReportMaster>();
try
{
using (GSTDB db = new GSTDB())
{
list = db.Tbl_ReportMaster.Where(x => x.ClientID == id).ToList();
}
}
catch (Exception)
{
}
return(list);
}
public static List <Tbl_ClientMaster> GetAllUsers(string name, string gst)
{
name = name.ToLower().Trim();
gst = gst.Trim();
using (GSTDB db = new GSTDB())
{
if (!string.IsNullOrEmpty(name))
{
return(db.Tbl_ClientMaster.Where(x => x.Name.ToLower().Contains(name)).ToList());
}
else if (!string.IsNullOrEmpty(gst))
{
return(db.Tbl_ClientMaster.Where(x => x.GST.Equals(gst)).ToList());
}
else
{
return(db.Tbl_ClientMaster.Where(x => x.GST.Equals(gst) && x.Name.ToLower().Contains(name)).ToList());
}
}
}
public static void SaveReport(Tbl_ReportMaster reportobj, LineItem list)
{
try
{
List <LineItemListClass> lineList = new List <LineItemListClass>();
int rowcount = list.cgst.Length;
for (int i = 0; i < rowcount; i++)
{
LineItemListClass Lineobj = new LineItemListClass()
{
itemname = list.itemname[i],
hsn = list.hsn[i],
uom = list.uom[i],
qty = list.qty[i],
rpu = list.rpu[i],
tvalue = list.tvalue[i],
rate = list.rate[i],
igst = list.igst[i],
sgst = list.sgst[i],
cgst = list.cgst[i],
utgst = list.utgst[i],
total = list.total[i],
cess = list.cess[i],
};
lineList.Add(Lineobj);
}
reportobj.ItemInfo = Newtonsoft.Json.JsonConvert.SerializeObject(lineList);
using (GSTDB db = new GSTDB())
{
db.Tbl_ReportMaster.Add(reportobj);
db.SaveChanges();
}
}
catch (Exception ex)
{
}
}
public static string GetStateName(int code)
{
string statename = string.Empty;
try
{
using (GSTDB db = new GSTDB())
{
var state = db.tbl_StateMaster.Where(x => x.Tin == code).FirstOrDefault();
if (state != null)
{
statename = (state.Tin < 10?"0":"") + state.Tin.ToString() + "-" + state.StateName;
}
else
{
statename = "";
}
}
}
catch (Exception ex)
{
}
return(statename);
}
public static void SaveUser(Tbl_ClientMaster obj, HttpPostedFileBase doc)
{
string filepath = System.Configuration.ConfigurationManager.AppSettings["SaveFilePath"];
using (GSTDB db = new GSTDB())
{
obj.DOJ = DateTime.Now;
db.Tbl_ClientMaster.Add(obj);
db.SaveChanges();
if (doc != null && doc.ContentLength > 0)
{
var fileName = Path.GetFileName(doc.FileName);
doc.SaveAs(Path.Combine(filepath, DateTime.Now.ToString("ddMMyyyy_" + obj.ClientID + ".jpg")));
}
Tbl_LoginMaster loginObj = new Tbl_LoginMaster();
loginObj.Email = obj.Mail1;
loginObj.UserName = (string.IsNullOrEmpty(obj.Mail1) ? obj.Mob1 : obj.Mail1);
loginObj.Password = "******";
loginObj.IsClient = true;
loginObj.CilientID = obj.ClientID;
db.Tbl_LoginMaster.Add(loginObj);
db.SaveChanges();
}
}
