public static bool CheckDouble(string categoryName)
{
try
{
if (companyId != 0)
{
SqlHelper helper = new SqlHelper();
// DataTable data = helper.CheckDoubleValues(companyId, branchId, "tbl_category", "category_name", useroremail);
IMS_TESTEntities context = new IMS_TESTEntities();
var data = context.tbl_category.Any(w => w.category_name == categoryName);
if (data)
{
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
ErrorLog.saveerror(ex);
}
return(true);
}
public static List <DashboardChartViewModel> GetChartData()
{
List <DashboardChartViewModel> list = new List <DashboardChartViewModel>();
try
{
if (HttpContext.Current.Session["company_id"] != null)
{
string a = "select top 5 sd.product_id, sum(sd.Quantity),p.product_name from tbl_saledetails sd inner join tbl_sale s on s.sale_id = sd.sale_id inner join tbl_product p on p.product_id = sd.product_id where s.company_id = 1008group by p.product_name, sd.product_id Order by sum(Quantity) desc";
IMS_TESTEntities context = new IMS_TESTEntities();
list = (from sd in context.tbl_saledetails
join p in context.tbl_product on sd.product_id equals p.product_id
join s in context.tbl_sale on sd.sale_id equals s.sale_id
where s.company_id == companyId
group sd by new { p.product_name, sd.product_id } into g
select new DashboardChartViewModel
{
ProductId = g.Select(f => f.product_id).FirstOrDefault(),
ProductName = g.Select(ty => ty.tbl_product.product_name).FirstOrDefault(),
Quantity = g.Sum(t3 => t3.quantity).Value
}
).Take(10).ToList();
return(list);
}
}
catch (Exception ex)
{
ErrorLog.saveerror(ex);
}
return(list);
}
public static void saveerror(Exception ex)
{
IMS_TESTEntities context = new IMS_TESTEntities();
string message = "";
message += Environment.NewLine;
message += "-----------------------------------------------------------";
message += Environment.NewLine;
message += string.Format("Message: {0}", ex.Message);
message += Environment.NewLine;
System.Diagnostics.StackTrace trace = new System.Diagnostics.StackTrace(ex, true);
//Console.WriteLine("Line: " + trace.GetFrame(0).GetFileLineNumber());
message += string.Format("StackTrace: {0}", trace.GetFrame(0).GetFileLineNumber());
message += Environment.NewLine;
message += string.Format("Source: {0}", ex.Source);
message += Environment.NewLine;
message += string.Format("TargetSite: {0}", ex.TargetSite.ToString());
message += Environment.NewLine;
message += string.Format("Error Url: {0}", ex.ToString());
message += Environment.NewLine;
message += "-----------------------------------------------------------";
message += Environment.NewLine;
using (SqlConnection con = new SqlConnection(CONNECTION_STRING))
{
using (SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.CommandText = "sp_saveerror";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@company_id", 1);
cmd.Parameters.AddWithValue("@branch_id", 1);
cmd.Parameters.AddWithValue("@error_type", ex.GetType().Name.ToString());
cmd.Parameters.AddWithValue("@error_msg", message.ToString());
cmd.Parameters.AddWithValue("@created_by", "Admin");
cmd.Parameters.AddWithValue("@created_date", DateTime.Now);
con.Open();
cmd.Connection = con;
cmd.ExecuteNonQuery();
con.Close();
}
}
//tbl_error_log tbl_error_log = new tbl_error_log();
//tbl_error_log.company_id = 1;
//tbl_error_log.branch_id = 1;
//tbl_error_log.error_type = ex.GetType().Name.ToString();
//tbl_error_log.error_msg = message.ToString();
//tbl_error_log.created_by = "Admin";
//tbl_error_log.created_date = DateTime.Now;
//context.tbl_error_log.Add(tbl_error_log);
//context.SaveChanges();
}
public static List <string> GetPoNumbers(string prefixText, int count)
{
IMS_TESTEntities context = new IMS_TESTEntities();
int year = DateTime.Now.Year;
prefixText = year.ToString() + "P" + prefixText;
var result = context.tbl_purchase.Where(p => p.InvoiceNumber.Contains(prefixText) && p.company_id == companyId);
List <string> customers = new List <string>();
customers = result.Select(p => p.InvoiceNumber).ToList <string>();
return(customers);
}
public static List <string> GetPoNumbers(string prefixText, int count)
{
IMS_TESTEntities context = new IMS_TESTEntities();
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["TestDBConnection"].ConnectionString;
using (SqlCommand cmd = new SqlCommand())
{
int year = DateTime.Now.Year;
prefixText = year.ToString() + "P" + prefixText;
var result = context.tbl_purchase.Where(p => p.InvoiceNumber.Contains(prefixText) && p.company_id == companyId);
List <string> customers = new List <string>();
customers = result.Select(p => p.InvoiceNumber).ToList <string>();
return(customers);
}
}
}
public static string[] ValidateQuantity(decimal enterdQuantity, int productid, int saleId)
{
string[] isfail = new string[2];
isfail[0] = "false";
isfail[1] = "";
IMS_TESTEntities context = new IMS_TESTEntities();
try
{
if (enterdQuantity != 0 && productid != 0)
{
if (companyId != 0 && saleId != 0)
{
SqlHelper helper = new SqlHelper();
var returnQuantity = context.GetReturnQuantity(saleId, Constants.Sale, productid, companyId).FirstOrDefault();
if (enterdQuantity > returnQuantity)
{
isfail[0] = "true";
isfail[1] = "Only " + returnQuantity + " can be return for the selected product.";
return(isfail);
}
}
}
else
{
isfail[0] = "true";
isfail[1] = "Please select product or enter correct return quantity.";
return(isfail);
}
//pass false as default if not true
isfail[0] = "false";
}
catch (Exception ex)
{
ErrorLog.saveerror(ex);
}
return(isfail);
}
public static string[] ValidateQuantity(decimal enterdQuantity, int productid, int purchaseId)
{
string[] isfail = new string[2];
isfail[0] = "false";
isfail[1] = "";
IMS_TESTEntities context = new IMS_TESTEntities();
// int purchaseId = Convert.ToInt32(hdnPurchaseId.Value);
try
{
if (enterdQuantity != 0 && productid != 0)
{
if (companyId != 0 && purchaseId != 0)
{
SqlHelper helper = new SqlHelper();
var stockQuantity = context.tbl_stock.Where(s => s.company_id == companyId && s.product_id == productid).FirstOrDefault();
var returnQuantity = context.GetReturnQuantity(purchaseId, Constants.Purchase, productid, companyId).FirstOrDefault();
if (enterdQuantity <= returnQuantity)
{
if (stockQuantity.qty < Convert.ToDecimal(enterdQuantity))
{
isfail[0] = "true";
//lblcheckDoubleError.Visible = true;
isfail[1] = "Insufficient stock quantity.";
return(isfail);
}
}
else
{
if (stockQuantity.qty <= returnQuantity)
{
isfail[0] = "true";
//lblcheckDoubleError.Visible = true;
isfail[1] = "Only " + stockQuantity.qty + " can be return for the selected product, Since some of item sold.";
return(isfail);
}
else
{
isfail[0] = "true";
//lblcheckDoubleError.Visible = true;
isfail[1] = "Only " + returnQuantity + " can be return for the selected product.";
return(isfail);
}
}
}
}
else
{
isfail[0] = "true";
//lblcheckDoubleError.Visible = true;
isfail[1] = "Please select product or enter correct return quantity.";
return(isfail);
}
//pass false as default if not true
isfail[0] = "false";
}
catch (Exception ex)
{
ErrorLog.saveerror(ex);
}
return(isfail);
}
public static void saveerror(Exception ex)
{
IMS_TESTEntities context = new IMS_TESTEntities();
string message = "";
message += Environment.NewLine;
message += "-----------------------------------------------------------";
message += Environment.NewLine;
message += string.Format("Message: {0}", ex.Message);
message += Environment.NewLine;
System.Diagnostics.StackTrace trace = new System.Diagnostics.StackTrace(ex, true);
//Console.WriteLine("Line: " + trace.GetFrame(0).GetFileLineNumber());
message += string.Format("StackTrace: {0}", trace.GetFrame(0).GetFileLineNumber());
message += Environment.NewLine;
message += string.Format("Source: {0}", ex.Source);
message += Environment.NewLine;
message += string.Format("TargetSite: {0}", ex.TargetSite.ToString());
message += Environment.NewLine;
message += string.Format("Error Url: {0}", ex.ToString());
message += Environment.NewLine;
message += "-----------------------------------------------------------";
message += Environment.NewLine;
//Code done by afrozz for dropdown and companyid and branch id
using (SqlConnection con = new SqlConnection(CONNECTION_STRING))
{
using (SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
var company = 0;
var branch = 0;
var createdby = "Auto Generated";
if ((HttpContext.Current.Session["regisFlag"] == null) && (HttpContext.Current.Session["company_id"] != null ||
HttpContext.Current.Session["branch_id"] != null || HttpContext.Current.Session["UserID"] != null))
{
company = Convert.ToInt32(HttpContext.Current.Session["company_id"]);
branch = Convert.ToInt32(HttpContext.Current.Session["branch_id"]);
createdby = HttpContext.Current.Session["UserID"].ToString();
}
cmd.CommandText = "sp_saveerror";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@company_id", company);
cmd.Parameters.AddWithValue("@branch_id", branch);
cmd.Parameters.AddWithValue("@error_type", ex.GetType().Name.ToString());
cmd.Parameters.AddWithValue("@error_msg", message.ToString());
cmd.Parameters.AddWithValue("@created_by", createdby);
cmd.Parameters.AddWithValue("@created_date", DateTime.Now);
con.Open();
cmd.Connection = con;
//cmd.ExecuteNonQuery();
Int32 ErrorId = (Int32)cmd.ExecuteScalar();
HttpContext.Current.Session["ErrorId"] = null;
HttpContext.Current.Session["ErrorId"] = ErrorId;
con.Close();
}
}
//tbl_error_log tbl_error_log = new tbl_error_log();
//tbl_error_log.company_id = 1;
//tbl_error_log.branch_id = 1;
//tbl_error_log.error_type = ex.GetType().Name.ToString();
//tbl_error_log.error_msg = message.ToString();
//tbl_error_log.created_by = "Admin";
//tbl_error_log.created_date = DateTime.Now;
//context.tbl_error_log.Add(tbl_error_log);
//context.SaveChanges();
}