protected void Page_Load(object sender, EventArgs e)
{
MyDB db = new MyDB();
string f_store = Session["storename"].ToString();
string f_dedcoll = Session["dedcolname"].ToString();
var f_coll = db.GetBColl(f_dedcoll);
IEnumerable <BsonValue> typesregex = f_coll.Distinct("type");
var outjson = "";
var outjsonconcat = "";
var varjson = "";
BsonElement btype = null;
BsonValue btypevalue = null;
BsonElement bmeasures = null;
string dums = null;
var jsonoffer = "";
foreach (string str in typesregex)
{
dums = null;
var query = new QueryDocument("type", str);
foreach (BsonDocument docs in f_coll.Find(query))
{
btype = docs.GetElement("type");
btypevalue = btype.Value;
bmeasures = docs.GetElement("measures");
string bmes = bmeasures.ToString();
var s = bmes.Replace(";", "\",\"");
var squareconcat = "[" + "\"" + s.Substring(9) + "\"" + "]";
var addtobson = squareconcat;
docs.Remove("_id");
docs.Remove("measures");
docs.Add("measures", addtobson);
varjson = docs.ToJson();
jsonoffer = MongoDB.Bson.Serialization.BsonSerializer.Deserialize <BsonDocument>(varjson.ToString()).ToString();
dums += jsonoffer.ToString() + ",";
}
outjsonconcat = "{\"category\":" + "\"" + btypevalue + "\"" + ",\"items\":[" + dums.Remove(dums.Length - 1, 1) + "]}" + ",";
outjson += outjsonconcat;
}
var stringremove = "[" + outjson.Remove(outjson.Length - 1, 1) + "]";
string path = @"F:\UGADHI\SS8\inventory\" + f_store + ".json";
if (!File.Exists(path))
{
File.Create(path);
TextWriter tw = new StreamWriter(path);
tw.WriteLine(stringremove.ToArray());
tw.Close();
}
else if (File.Exists(path))
{
TextWriter tw = new StreamWriter(path, false); //false here to "Replace" the file content, instead of appending it.
tw.WriteLine(stringremove.ToArray());
tw.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
var userid = Session["objid"].ToString();
//var userid = "52ca747eeb12480278147796";
var loginjson = Request["reqdata"];
BsonDocument t = MongoDB.Bson.Serialization.BsonSerializer.Deserialize <BsonDocument>(loginjson);
int startindex = Convert.ToInt32(t.GetElement("si1").Value);
int limitindex = Convert.ToInt32(t.GetElement("li1").Value);
int restartindex = startindex - 20;
MyDB db = new MyDB();
var coll = db.GetBColl("Test3");
var userq = Query.EQ("user", userid);
var collord = coll.Find(userq);
var totalorders = collord.Count();
var totalorders1 = totalorders - 1;
if (totalorders == 0)
{
Response.Clear();
Response.CacheControl = "no-cache";
Response.ContentType = "application/json";
Response.Write("0");
Response.End();
}
var query = from person in coll.Find(userq)
orderby person.ToBsonDocument().GetElement("ISODate") descending
select person;
var mc = query.ToArray();
var obj = "";
var obj1 = "";
BsonElement my_id = null;
for (int i = restartindex; i < limitindex; i++)
{
if (i < totalorders) // 21
{
var tobson = mc[i].ToBsonDocument();
my_id = tobson.GetElement("_id");
tobson.Add("orderid", my_id.ToString().Substring(4));
tobson.Remove("ISODate");
tobson.Remove("_id");
BsonElement bmob = tobson.GetElement("mobile");
tobson.Remove("mobile");
tobson.Add("mobile", Convert.ToDouble(bmob.Value));
var myf = tobson.ToJson();
if (i == totalorders1) // 20 == 20
{
var jsonoffer = MongoDB.Bson.Serialization.BsonSerializer.Deserialize <BsonDocument>(myf.ToString());
obj += jsonoffer.ToString();
obj1 = obj;
var obj22 = obj1;
//var objrem1 = obj22.Remove(obj22.Length - 1, 1);
var finalString1 = "{\"orders\":[" + obj22 + "]}";
BsonDocument bie = new BsonDocument();
bie.Add("obj", finalString1);
bie.Add("resp", Convert.ToDouble(totalorders));
var myresp = bie.ToJson();
var lastresp = MongoDB.Bson.Serialization.BsonSerializer.Deserialize <BsonDocument>(myresp.ToString());
Response.Clear();
Response.CacheControl = "no-cache";
Response.ContentType = "application/json";
Response.Write(lastresp.ToString());
Response.End();
}
else
{
var jsonoffer = MongoDB.Bson.Serialization.BsonSerializer.Deserialize <BsonDocument>(myf.ToString());
obj += jsonoffer.ToString() + ",";
obj1 = obj;
}
}
//if (i == totalorders) //62 == 62
//{
// var obj22 = obj1;
// //var objrem1 = obj22.Remove(obj22.Length - 1, 1);
// var finalString1 = "{\"orders\":[" + objrem1 + "]}";
// Response.Clear();
// Response.CacheControl = "no-cache";
// Response.ContentType = "application/json";
// Response.Write(finalString1);
// Response.End();
// //Response.Clear();
// //Response.CacheControl = "no-cache";
// //Response.ContentType = "application/json";
// //string str = null;
// //Response.Write(str);
// //Response.End();
//}
}
var obj2 = obj1;
var objrem = obj2.Remove(obj2.Length - 1, 1);
//var myres = "[" + objrem + "]";
//var ome = '{' + "Data" + myres + '}';
var finalString = "{\"orders\":[" + objrem + "]}";
//var stringremove = "{" + finalString;
//var obj2 = obj1;
//var objrem = obj2.Remove(obj2.Length - 1, 1);
//objrem = "{\"Prudhvi\":[" + objrem + "]}";
Response.Clear();
Response.CacheControl = "no-cache";
Response.ContentType = "application/json";
//coll3.Drop();
Response.Write(finalString);
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
MyDB md = new MyDB();
var gcoll = md.GetBColl("guests");
string gdums = null;
var gjson = "";
var gjsonconcat = "";
var storesession = Session["storename"].ToString();
//var gquery = new QueryDocument("order.storeName", storesession);
var gquery = Query.EQ("order.storeName", storesession);
var mc = gcoll.Find(gquery).ToArray();
for (var i = 0; i < mc.Count(); i++)
{
BsonDocument bgdoc = mc[i].ToBsonDocument();
BsonElement objectid = bgdoc.GetElement("_id");
bgdoc.Add("orderid", objectid.Value.ToString());
bgdoc.Remove("_id");
gjson = bgdoc.ToJson();
var jsonoffer = MongoDB.Bson.Serialization.BsonSerializer.Deserialize <BsonDocument>(gjson.ToString());
gdums += jsonoffer.ToString() + ",";
}
gjsonconcat = gdums;
var gstringremove = gjsonconcat;
string dums = null;
var outjson = "";
var outjsonconcat = "";
var varjson = "";
var coll = md.GetBColl("orders");
BsonElement buser = null;
BsonValue buservalue = null;
BsonElement bcname = null;
BsonElement bmob = null;
BsonValue busernamevalue = null;
BsonElement my_id = null;
dums = null;
var mcord = coll.Find(gquery).ToArray();
for (var j = 0; j < mcord.Count(); j++)
{
BsonDocument bids = mcord[j].ToBsonDocument();
my_id = bids.GetElement("_id");
bids.Add("orderid", my_id.ToString().Substring(4));
buser = bids.GetElement("user");
buservalue = buser.Value;
bmob = bids.GetElement("mobile");
bids.Remove("mobile");
var regcoll = md.GetBColl("registration");
var query1 = new QueryDocument("_id", ObjectId.Parse(buservalue.ToString()));
foreach (BsonDocument bc in regcoll.Find(query1))
{
bcname = bc.GetElement("name");
}
busernamevalue = bcname.Value;
bids.Add("mobile", Convert.ToDouble(bmob.Value));
bids.Add("name", busernamevalue);
bids.Remove("_id");
//bids.Remove("shipadd");
bids.Remove("user");
varjson = bids.ToJson();
var jsonoffer = MongoDB.Bson.Serialization.BsonSerializer.Deserialize <BsonDocument>(varjson.ToString());
dums += jsonoffer.ToString() + ",";
}
outjsonconcat = dums + gstringremove;
outjson += outjsonconcat;
var finalString = "\"Prudhvi\":[" + outjson.Remove(outjson.Length - 1, 1) + "]}" + ",";
var stringremove = "{" + finalString.Remove(finalString.Length - 1, 1);
//var stringremove = "{Prudhvi:[" + outjson.Remove(outjson.Length - 1, 1) + "]}";
Response.Clear();
Response.CacheControl = "no-cache";
Response.ContentType = "application/json";
Response.Write(stringremove.ToString());
Response.End();
}
catch (ThreadAbortException ee) { }
catch (Exception eee)
{
Response.Clear();
Response.CacheControl = "no-cache";
Response.ContentType = "application/json";
Response.Write("exception"); //Valid User
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
var data = Request["sendeddata"];
BsonArray p = MongoDB.Bson.Serialization.BsonSerializer.Deserialize <BsonArray>(data);
MyDB db = new MyDB();
string orgcollsess = Session["dedcolname"].ToString();
var orgcoll = db.GetBColl(orgcollsess);
string dumcollstr = orgcollsess + "dummy";
var dumcoll = db.GetBColl(dumcollstr);
foreach (BsonDocument bids in p)
{
BsonValue objid = bids.GetElement("_id").Value;
orgcoll.Insert(bids);
var dumquery = new QueryDocument("_id", ObjectId.Parse(objid.ToString()));
dumcoll.Remove(dumquery);
}
string f_dedcoll = Session["dedcolname"].ToString();
var f_coll = db.GetBColl(f_dedcoll);
IEnumerable <BsonValue> typesregex = f_coll.Distinct("type");
var outjson = "";
var outjsonconcat = "";
var varjson = "";
BsonElement btype = null;
BsonValue btypevalue = null;
BsonElement bmeasures = null;
string dums = null;
var jsonoffer = "";
foreach (string str in typesregex)
{
dums = null;
var query = new QueryDocument("type", str);
foreach (BsonDocument docs in f_coll.Find(query))
{
btype = docs.GetElement("type");
btypevalue = btype.Value;
bmeasures = docs.GetElement("measures");
string bmes = bmeasures.ToString();
var s = bmes.Replace(";", "\",\"");
var squareconcat = "[" + "\"" + s.Substring(9) + "\"" + "]";
var addtobson = squareconcat;
docs.Remove("_id");
docs.Remove("measures");
docs.Add("measures", addtobson);
varjson = docs.ToJson();
jsonoffer = MongoDB.Bson.Serialization.BsonSerializer.Deserialize <BsonDocument>(varjson.ToString()).ToString();
dums += jsonoffer.ToString() + ",";
}
outjsonconcat = "{\"category\":" + "\"" + btypevalue + "\"" + ",\"items\":[" + dums.Remove(dums.Length - 1, 1) + "]}" + ",";
outjson += outjsonconcat;
}
var stringremove = "[" + outjson.Remove(outjson.Length - 1, 1) + "]";
string fstore = Session["storename"].ToString();
string path = Server.MapPath("~/inventory/") + fstore + ".json";
if (!File.Exists(path))
{
FileStream fs = new FileStream(path, FileMode.OpenOrCreate);
StreamWriter str11 = new StreamWriter(fs);
str11.WriteLine(stringremove.ToArray());
str11.Flush();
str11.Close();
fs.Dispose();
fs.Close();
}
else if (File.Exists(path))
{
FileStream fs = new FileStream(path, FileMode.Open);
StreamWriter str12 = new StreamWriter(fs);
str12.WriteLine(stringremove.ToArray());
str12.Flush();
str12.Close();
fs.Dispose();
fs.Close();
}
Response.Clear();
Response.CacheControl = "no-cache";
Response.ContentType = "application/json";
Response.Write("1");
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var obj = Request["reqdata"];
BsonDocument t = MongoDB.Bson.Serialization.BsonSerializer.Deserialize <BsonDocument>(obj);
BsonValue objOrg = t.GetElement("originalGridData").Value;
BsonValue objDummy = t.GetElement("dummyGridData").Value;
MyDB db = new MyDB();
string merchatsess = Session["dedcolname"].ToString();
string merchdummycoll = Session["dummycol"].ToString();
var coll = db.GetBColl(merchatsess);
var dummycoll = db.GetBColl(merchdummycoll);
if (coll.Count() > 0)
{
coll.Drop();
}
List <object> orgList = new List <object>();
BsonDocument bexp = new BsonDocument();
var coll77 = db.GetBColl(merchatsess);
for (int i = 0; i <= objOrg.AsBsonArray.Count - 1; i++)
{
bexp = new BsonDocument();
var bids = objOrg[i].AsBsonDocument;
bexp.AddRange(bids);
orgList.Add(bexp);
bexp = null;
}
coll77.InsertBatch(orgList);
BsonDocument bdums = new BsonDocument();
BsonDocument bdums1 = new BsonDocument();
var dummycount = dummycoll.Count();
if (dummycoll.Exists() && dummycount > 0)
{
var maxsnosno = dummycoll.FindAll().SetSortOrder(SortBy.Descending("sno")).SetLimit(1).FirstOrDefault();
var bsonsno = maxsnosno.GetElement("sno").Value;
var longsno = Convert.ToInt64(bsonsno);
for (int i = 0; i <= objDummy.AsBsonArray.Count - 1; i++)
{
longsno++;
bdums = new BsonDocument();
Dictionary <string, long> dict = new Dictionary <string, long>();
dict.Add("sno", longsno);
var biddums = objDummy[i].AsBsonDocument;
bdums.AddRange(biddums);
bdums.AddRange(dict);
dummycoll.Insert(bdums);
bdums = null;
}
}
else
{
var longsno1 = 0;
for (int i = 0; i <= objDummy.AsBsonArray.Count - 1; i++)
{
longsno1++;
bdums1 = new BsonDocument();
Dictionary <string, long> mydict = new Dictionary <string, long>();
mydict.Add("sno", longsno1);
var biddums1 = objDummy[i].AsBsonDocument;
bdums1.AddRange(biddums1);
bdums1.AddRange(mydict);
dummycoll.Insert(bdums1);
bdums1 = null;
}
}
string f_dedcoll = Session["dedcolname"].ToString();
var f_coll = db.GetBColl(f_dedcoll);
IEnumerable <BsonValue> typesregex = f_coll.Distinct("type");
var outjson = "";
var outjsonconcat = "";
var varjson = "";
BsonElement btype = null;
BsonValue btypevalue = null;
BsonElement bmeasures = null;
string dums = null;
var jsonoffer = "";
foreach (string str in typesregex)
{
dums = null;
var query = new QueryDocument("type", str);
foreach (BsonDocument docs in f_coll.Find(query))
{
btype = docs.GetElement("type");
btypevalue = btype.Value;
bmeasures = docs.GetElement("measures");
string bmes = bmeasures.ToString();
var s = bmes.Replace(";", "\",\"");
var squareconcat = "[" + "\"" + s.Substring(9) + "\"" + "]";
var addtobson = MongoDB.Bson.Serialization.BsonSerializer.Deserialize <BsonValue>(squareconcat);
docs.Remove("_id");
docs.Remove("measures");
docs.Add("measures", addtobson);
varjson = docs.ToJson();
jsonoffer = MongoDB.Bson.Serialization.BsonSerializer.Deserialize <BsonDocument>(varjson.ToString()).ToString();
dums += jsonoffer.ToString() + ",";
}
outjsonconcat = "{\"category\":" + "\"" + btypevalue + "\"" + ",\"items\":[" + dums.Remove(dums.Length - 1, 1) + "]}" + ",";
outjson += outjsonconcat;
}
var stringremove = "[" + outjson.Remove(outjson.Length - 1, 1) + "]";
string fstore = Session["storename"].ToString();
string path = Server.MapPath("~/inventory/") + fstore + ".json";
if (!File.Exists(path))
{
FileStream fs = new FileStream(path, FileMode.OpenOrCreate);
StreamWriter str11 = new StreamWriter(fs);
str11.WriteLine(stringremove.ToArray());
str11.Flush();
str11.Close();
fs.Dispose();
fs.Close();
}
else if (File.Exists(path))
{
FileStream fs = new FileStream(path, FileMode.Open);
StreamWriter str12 = new StreamWriter(fs);
str12.WriteLine(stringremove.ToArray());
str12.Flush();
str12.Close();
fs.Dispose();
fs.Close();
}
Response.Clear();
Response.CacheControl = "no-cache";
Response.ContentType = "application/json";
Response.Write("777");
Response.End();
}
catch (ThreadAbortException e4)
{
}
catch (IOException e3)
{
}
catch (Exception e2)
{
Response.Clear();
Response.CacheControl = "no-cache";
Response.ContentType = "application/json";
Response.Write("exception");
Response.End();
}
finally
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
var loginjson = Request["reqdata"];
BsonDocument t = MongoDB.Bson.Serialization.BsonSerializer.Deserialize <BsonDocument>(loginjson);
int startindex = Convert.ToInt32(t.GetElement("si1").Value);
int limitindex = Convert.ToInt32(t.GetElement("li1").Value);
var storesession = Session["storename"].ToString();
var usersess = Session["objid"].ToString();
var gquery = Query.EQ("order.storeName", storesession);
int restartindex = startindex - 20;
MyDB db = new MyDB();
var coll = db.GetBColl("Test3");
var coll3 = db.GetBColl("Test4" + usersess);
if (restartindex == 0 && !(coll3.Exists()))
{
if (coll.Find(gquery).Count() > 0)
{
coll3.InsertBatch(coll.Find(gquery));
}
}
var totalorders = coll3.Count();
var totalorders1 = totalorders - 1;
if (totalorders == 0)
{
Response.Clear();
Response.CacheControl = "no-cache";
Response.ContentType = "application/json";
Response.Write("0");
Response.End();
}
var query = from person in coll3.FindAll()
orderby person.ToBsonDocument().GetElement("ISODate") descending
select person;
var mc = query.ToArray();
var obj = "";
var obj1 = "";
BsonElement my_id = null;
for (int i = restartindex; i < limitindex; i++)
{
if (i < totalorders) // 60 61
{
var tobson = mc[i].ToBsonDocument();
my_id = tobson.GetElement("_id");
tobson.Add("orderid", my_id.ToString().Substring(4));
tobson.Remove("ISODate");
tobson.Remove("_id");
BsonElement bmob = tobson.GetElement("mobile");
tobson.Remove("mobile");
tobson.Add("mobile", Convert.ToDouble(bmob.Value));
var myf = tobson.ToJson();
if (i == totalorders1)
{
var jsonoffer = MongoDB.Bson.Serialization.BsonSerializer.Deserialize <BsonDocument>(myf.ToString());
obj += jsonoffer.ToString();
obj1 = obj;
var obj22 = obj1;
var finalString1 = "{\"orders\":[" + obj22 + "]}";
BsonDocument bie = new BsonDocument();
bie.Add("obj", finalString1);
bie.Add("resp", Convert.ToDouble(totalorders));
var myresp = bie.ToJson();
var lastresp = MongoDB.Bson.Serialization.BsonSerializer.Deserialize <BsonDocument>(myresp.ToString());
Response.Clear();
Response.CacheControl = "no-cache";
Response.ContentType = "application/json";
Response.Write(lastresp.ToString());
Response.End();
}
else
{
var jsonoffer = MongoDB.Bson.Serialization.BsonSerializer.Deserialize <BsonDocument>(myf.ToString());
obj += jsonoffer.ToString() + ",";
obj1 = obj;
}
}
}
var obj2 = obj1;
var objrem = obj2.Remove(obj2.Length - 1, 1);
var finalString = "{\"orders\":[" + objrem + "]}";
Response.Clear();
Response.CacheControl = "no-cache";
Response.ContentType = "application/json";
Response.Write(finalString);
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var selectedStore = Request["val"];
Session["selstore"] = selectedStore;
MyDB db = new MyDB();
var coll = db.GetBColl("registration");
var query = new QueryDocument("storename", selectedStore);
BsonElement bmerchantcollname = null;
BsonValue bmerchantcollnamevalue = null;
foreach (BsonDocument bcat in coll.Find(query))
{
bmerchantcollname = bcat.GetElement("colname");
bmerchantcollnamevalue = bmerchantcollname.Value;
}
//var merchcol = db.GetBColl("bakkupavankumar7382476952");
var merchcol = db.GetBColl(bmerchantcollnamevalue.ToString());
IEnumerable <BsonValue> typesregex = merchcol.Distinct("type");
var outjson = "";
var outjsonconcat = "";
var varjson = "";
BsonElement btype = null;
BsonValue btypevalue = null;
BsonElement bmeasures = null;
BsonElement boffer = null;
string dums = null;
var jsonoffer = "";
foreach (string str in typesregex)
{
dums = null;
var query1 = new QueryDocument("type", str);
foreach (BsonDocument docs in merchcol.Find(query1))
{
btype = docs.GetElement("type");
btypevalue = btype.Value;
boffer = docs.GetElement("offer");
var offervalue = boffer.Value;
bmeasures = docs.GetElement("measures");
string bmes = bmeasures.ToString();
var s = bmes.Replace(";", "\",\"");
var squareconcat = "[\"" + "1" + "\",\"" + "1.5" + "\",\"" + "2" + "\",\"" + "2.5" + "\",\"" + "3" + "\",\"" + "5" + "\",\"" + "10" + "\"]";
var addtobson = squareconcat;
docs.Remove("_id");
docs.Remove("measures");
docs.Add("measures", addtobson);
varjson = docs.ToJson();
jsonoffer = MongoDB.Bson.Serialization.BsonSerializer.Deserialize <BsonDocument>(varjson.ToString()).ToString();
dums += jsonoffer.ToString() + ",";
}
outjsonconcat += "{\"category\":" + "\"" + btypevalue + "\"" + ",\"items\":[" + dums.Remove(dums.Length - 1, 1) + "]}" + ",";
outjson = outjsonconcat;
}
var stringremove = "[" + outjson.Remove(outjson.Length - 1, 1) + "]";
outjson.Remove(outjson.Length - 1, 1);
FileInfo fi = new FileInfo(Server.MapPath("inventory/" + selectedStore + ".json"));
if (!File.Exists(Server.MapPath("inventory/" + selectedStore + ".json").ToString()))
{
File.Create(Server.MapPath("inventory/" + selectedStore + ".json").ToString());
using (TextWriter tw = new StreamWriter(fi.Open(FileMode.Truncate)))
{
tw.Write(stringremove);
//fi.Refresh();
}
}
else //if (File.Exists(Server.MapPath("inventory/" + selectedStore + ".json").ToString()))
{
using (TextWriter tw = new StreamWriter(fi.Open(FileMode.Truncate)))
{
tw.Write(stringremove);
//fi.Refresh();
}
}
}
catch (ThreadAbortException ee) { }
catch (Exception eee)
{
Response.Clear();
Response.CacheControl = "no-cache";
Response.ContentType = "application/json";
Response.Write("exception"); //Valid User
Response.End();
}
}
