public static int UnseenOrd(int OrgId) { string Query = "SELECT distinct TickedNo,OID FROM HG_OrderItem WHERE (Status=1 or Status=2) and OID In(select OID from HG_Orders where Status='1' "; int Count = 0; HG_OrganizationDetails ObjOrg = new HG_OrganizationDetails().GetOne(OrgId); if (OrgId == 0 || (ObjOrg.OrgID > 0 && ObjOrg.PaymentType == 1)) { Query = "SELECT distinct TickedNo,OID FROM HG_OrderItem WHERE (Status=1 or Status=2) and OID In(select OID from HG_Orders where Status='1' and PaymentStatus!= 0 "; } if (OrgId > 0) { Query += "and OrgId=" + OrgId.ToString() + " )"; } else { Query += ")"; } System.Data.SqlClient.SqlCommand cmd = null; System.Data.SqlClient.SqlDataReader SDR = null; HG_OrderItem ObjTmp = new HG_OrderItem(); DBCon Obj = new DBCon(); try { cmd = new System.Data.SqlClient.SqlCommand(Query, Obj.Con); SDR = cmd.ExecuteReader(); while (SDR.Read()) { Count = Count + 1; } } catch (System.Exception e) { e.ToString(); } finally { cmd.Dispose(); SDR.Close(); Obj.Con.Close(); Obj.Con.Dispose(); Obj.Con = null; } return(Count); }
public HG_OrganizationDetails GetOne(int OrgID) { SqlConnection Con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Con"].ToString()); Con.Open(); SqlCommand cmd = null; SqlDataReader SDR = null; HG_OrganizationDetails ObjTmp = new HG_OrganizationDetails(); try { string Query = "SELECT * FROM HG_OrganizationDetails where OrgID =@OrgID "; cmd = new SqlCommand(Query, Con); cmd.Parameters.AddWithValue("@OrgID ", OrgID); SDR = cmd.ExecuteReader(); while (SDR.Read()) { ObjTmp.OrgID = SDR.GetInt32(0); ObjTmp.OrgTypes = SDR.GetString(1); ObjTmp.HeadName = SDR.GetString(2); ObjTmp.Name = SDR.GetString(3); ObjTmp.Address = SDR.GetString(4); ObjTmp.City = SDR.GetString(5); ObjTmp.State = SDR.GetString(6); ObjTmp.PinCode = SDR.GetString(7); ObjTmp.Phone = SDR.GetString(8); ObjTmp.Cell = SDR.GetString(9); ObjTmp.Email = SDR.GetString(10); ObjTmp.WebSite = SDR.GetString(11); ObjTmp.Logo = SDR.GetString(12); ObjTmp.GSTNO = SDR.GetString(15); ObjTmp.PANNO = SDR.GetString(16); ObjTmp.BankName = SDR.GetString(17); ObjTmp.ACNO = SDR.GetString(18); ObjTmp.AcType = SDR.GetString(19); ObjTmp.Status = SDR.GetBoolean(23); ObjTmp.PaymentType = SDR.IsDBNull(24) ? 1 : SDR.GetInt32(24); ObjTmp.IvoiceHeading = SDR.IsDBNull(25) ? " " : SDR.GetString(25); ObjTmp.AddressLin2 = SDR.IsDBNull(26) ? " " : SDR.GetString(26); ObjTmp.AddressLine3 = SDR.IsDBNull(27) ? " " : SDR.GetString(27); ObjTmp.Licence2 = SDR.IsDBNull(28) ? " " : SDR.GetString(28); ObjTmp.License3 = SDR.IsDBNull(29) ? " " : SDR.GetString(29); ObjTmp.PrintRemark = SDR.GetString(30); ObjTmp.CustomerOrdering = SDR.GetBoolean(31); ObjTmp.InvoiceTitle = SDR.GetString(32); ObjTmp.invoicePhone = SDR.GetString(33); ObjTmp.DistrictId = SDR.GetInt32(34); ObjTmp.InvoicePrintting = SDR.GetInt32(35); ObjTmp.NuOfCopy = SDR.GetInt32(36); ObjTmp.OrderDisplay = SDR.GetInt32(37); ObjTmp.PrinttingType = SDR.GetInt32(38); ObjTmp.Copy = SDR.GetInt32(39); ObjTmp.WalletAmt = SDR.GetDouble(40); } } catch (Exception e) { e.ToString(); } finally { Con.Close(); } return(ObjTmp); }
public List <HG_OrganizationDetails> GetAll(int Orgid = 0) { var CurrOrgID = HttpContext.Current.Request.Cookies["UserInfo"]; SqlConnection Con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Con"].ToString()); Con.Open(); SqlCommand cmd = null; SqlDataReader SDR = null; List <HG_OrganizationDetails> ListTmp = new List <HG_OrganizationDetails>(); string Query = "SELECT * FROM HG_OrganizationDetails ORDER BY OrgID DESC"; if (OrgID > 0) { Query = "SELECT * FROM HG_OrganizationDetails where OrgID=" + OrgID.ToString() + " ORDER BY OrgID DESC"; } else if (CurrOrgID != null && int.Parse(CurrOrgID["OrgId"]) > 0) { Query = "SELECT * FROM HG_OrganizationDetails where OrgID=" + CurrOrgID["OrgId"] + " ORDER BY OrgID DESC"; } try { cmd = new SqlCommand(Query, Con); SDR = cmd.ExecuteReader(); while (SDR.Read()) { HG_OrganizationDetails ObjTmp = new HG_OrganizationDetails(); ObjTmp.OrgID = SDR.GetInt32(0); ObjTmp.OrgTypes = SDR.GetString(1); ObjTmp.HeadName = SDR.GetString(2); ObjTmp.Name = SDR.GetString(3); ObjTmp.Address = SDR.GetString(4); ObjTmp.City = SDR.GetString(5); ObjTmp.State = SDR.GetString(6); ObjTmp.PinCode = SDR.GetString(7); ObjTmp.Phone = SDR.GetString(8); ObjTmp.Cell = SDR.GetString(9); ObjTmp.Email = SDR.GetString(10); ObjTmp.WebSite = SDR.GetString(11); ObjTmp.Logo = SDR.GetString(12); ObjTmp.GSTNO = SDR.GetString(15); ObjTmp.PANNO = SDR.GetString(16); ObjTmp.BankName = SDR.GetString(17); ObjTmp.ACNO = SDR.GetString(18); ObjTmp.AcType = SDR.GetString(19); ObjTmp.Status = SDR.GetBoolean(23); ObjTmp.PaymentType = SDR.IsDBNull(24)?1: SDR.GetInt32(24); ObjTmp.IvoiceHeading = SDR.IsDBNull(25) ? " " : SDR.GetString(25); ObjTmp.AddressLin2 = SDR.IsDBNull(26) ? " " : SDR.GetString(26); ObjTmp.AddressLine3 = SDR.IsDBNull(27) ? " " : SDR.GetString(27); ObjTmp.Licence2 = SDR.IsDBNull(28) ? " " : SDR.GetString(28); ObjTmp.License3 = SDR.IsDBNull(29) ? " " : SDR.GetString(29); ObjTmp.PrintRemark = SDR.GetString(30); ObjTmp.CustomerOrdering = SDR.GetBoolean(31); ObjTmp.InvoiceTitle = SDR.GetString(32); ObjTmp.invoicePhone = SDR.GetString(33); ObjTmp.DistrictId = SDR.GetInt32(34); ObjTmp.InvoicePrintting = SDR.GetInt32(35); ObjTmp.NuOfCopy = SDR.GetInt32(36); ObjTmp.OrderDisplay = SDR.GetInt32(37); ObjTmp.PrinttingType = SDR.GetInt32(38); ObjTmp.Copy = SDR.GetInt32(39); ObjTmp.WalletAmt = SDR.GetDouble(40); ListTmp.Add(ObjTmp); } } catch (System.Exception e) { e.ToString(); } finally { Con.Close(); } return(ListTmp); }