public ActionResult FormEdit(int id, string formtype, FORMLines FormLines)
{
LoginCheck();
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["PTEKNIKMSSQL"].ConnectionString))
{
string MontajDate = Convert.ToDateTime(((FormLines.MONTAJDATE == null) ? DateTime.Parse("1900-01-01") : FormLines.MONTAJDATE)).ToString("MM/dd/yyyy");
string ARIZADATE = Convert.ToDateTime(((FormLines.ARIZADATE == null) ? DateTime.Parse("1900-01-01") : FormLines.ARIZADATE)).ToString("MM/dd/yyyy");
string FatDate = Convert.ToDateTime(((FormLines.FATURADATE == null) ? DateTime.Parse("1900-01-01") : FormLines.FATURADATE)).ToString("MM/dd/yyyy");
string sqlQuery = "update [dbo].[FORMLINE] set " +
"BELGENO=" + FormLines.BELGENO + "" +
",BELGESTR='" + FormLines.BELGESTR + "'" +
",ADSOYAD='" + FormLines.ADSOYAD + "'" +
",ADRES='" + FormLines.ADRES + "'" +
",TEL='" + FormLines.TEL + "'" +
",TEL2='" + FormLines.TEL2 + "'" +
",EMAIL='" + FormLines.EMAIL + "'" +
",MONTAJDATE='" + MontajDate + "'" +
",ARIZADATE='" + ARIZADATE + "'" +
",FIRMA='" + FormLines.FIRMA + "'" +
",SATICIFIRMA='" + FormLines.SATICIFIRMA + "'" +
",FATURADATE='" + Convert.ToDateTime(FatDate).ToString("MM/dd/yyyy") + "'" +
",FATURANO='" + FormLines.FATURANO + "'" +
",GARANTINO='" + FormLines.GARANTINO + "'" +
",CIHAZ='" + FormLines.CIHAZ + "'" +
",CIHAZSERINO='" + FormLines.CIHAZSERINO + "',DURUM=1" +
",CACIKLAMA='" + FormLines.CACIKLAMA + "'" +
" WHERE LOGICALREF=" + id;
int rowsAffected = db.Execute(sqlQuery);
}
return(RedirectToAction("Index"));
}
public ActionResult FormAdd(FORMLines FormLines)
{
LoginCheck();
//zorunlu alan kontrolü
if (FormLines.TEL == "" && FormLines.TEL2 == "")
{
return(View());
}
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["PTEKNIKMSSQL"].ConnectionString))
{
string sqlQuery = "INSERT INTO [dbo].[FORMLINE]([BELGENO],[BELGESTR],[ADSOYAD],[ADRES],[TEL],[TEL2],[EMAIL],[MONTAJDATE],[ARIZADATE],[FIRMA],[SATICIFIRMA],[FATURADATE],[FATURANO],[GARANTINO],[CIHAZ],[CIHAZSERINO])VALUES" +
"(" + FormLines.BELGENO + "" +
",'" + FormLines.BELGESTR + "'" +
",'" + FormLines.ADSOYAD + "'" +
",'" + FormLines.ADRES + "'" +
",'" + FormLines.TEL + "'" +
",'" + FormLines.TEL2 + "'" +
",'" + FormLines.EMAIL + "'" +
",cast('" + Convert.ToDateTime(FormLines.MONTAJDATE).ToString("MM/dd/yyyy") + "' as datetime)" +
",cast('" + Convert.ToDateTime(FormLines.ARIZADATE).ToString("MM/dd/yyyy") + "' as datetime)" +
",'" + FormLines.FIRMA + "'" +
",'" + FormLines.SATICIFIRMA + "'" +
",cast('" + Convert.ToDateTime(FormLines.FATURADATE).ToString("MM/dd/yyyy") + "' as datetime)" +
",'" + FormLines.FATURANO + "'" +
",'" + FormLines.GARANTINO + "'" +
",'" + FormLines.CIHAZ + "'" +
",'" + FormLines.CIHAZSERINO + "')";
int rowsAffected = db.Execute(sqlQuery);
}
return(RedirectToAction("FormList", "Forms", new { @formtype = FormLines.FORMTYPE }));
}
// GET: Forms/Create
public ActionResult FormAdd(string formtype)
{
LoginCheck();
if (formtype == "Arıza")
{
ViewData["FormAddTitle"] = "Arıza Formu Ekranı";
ViewData["montajdateStyle"] = "display:none";
}
else if (formtype == "montaj")
{
ViewData["FormAddTitle"] = "Montaj Formu Ekranı";
ViewData["arizadateStyle"] = "display:none";
}
else
{
return(Redirect("Index"));
}
FORMLines _DefaultModel = new FORMLines();
_DefaultModel.BELGENO = Convert.ToInt32(GLOBALS.GetCookie("giris")["BELGEID"]);
_DefaultModel.BELGESTR = GLOBALS.GetCookie("giris")["CLIENTREF"];
_DefaultModel.FORMTYPE = formtype;
_DefaultModel.MONTAJDATE = DateTime.Now;
_DefaultModel.ARIZADATE = DateTime.Now;
_DefaultModel.FATURADATE = DateTime.Now;
return(View(_DefaultModel));
}
public ActionResult FormOnizle(string ficheno)
{
FORMLines _formLines = new FORMLines();
using (db)
{
_formLines = db.Query <FORMLines>("select * from FORMLINE where FICHENO='" + ficheno + "'").SingleOrDefault();
}
return(View(_formLines));
}
public ActionResult FormKaydetJQ(FORMLines FormLines)
{
//zorunlu alan kontrolü
if (FormLines.TEL == "" && FormLines.TEL2 == "")
{
return(View());
}
string MontajDate = Convert.ToDateTime(((FormLines.MONTAJDATE == null) ? DateTime.Parse("1900-01-01") : FormLines.MONTAJDATE)).ToString("MM/dd/yyyy");
string ARIZADATE = Convert.ToDateTime(((FormLines.ARIZADATE == null) ? DateTime.Parse("1900-01-01") : FormLines.ARIZADATE)).ToString("MM/dd/yyyy");
string FatDate = Convert.ToDateTime(((FormLines.FATURADATE == null) ? DateTime.Parse("1900-01-01") : FormLines.FATURADATE)).ToString("MM/dd/yyyy");
bool durum = true;
if ((FormLines.FORMTYPE == "montaj" && FormLines.MONTAJDATE > DateTime.Now) || (FormLines.FORMTYPE == "Arıza" && FormLines.ARIZADATE > DateTime.Now))
{
durum = false;
}
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["PTEKNIKMSSQL"].ConnectionString))
{
string sqlQuery = "INSERT INTO [dbo].[FORMLINE](FORMTYPE,FICHENO,[BELGENO],[BELGESTR],[ADSOYAD],[ADRES],[TEL],[TEL2],[EMAIL],[MONTAJDATE],[ARIZADATE],[FIRMA],[SATICIFIRMA],[FATURADATE],[FATURANO],[GARANTINO],[CIHAZ],[CIHAZSERINO],CLIENTREF)VALUES" +
"('" + FormLines.FORMTYPE + "','" + FormLines.BELGESTR + "-" + FormLines.BELGENO + "'," + FormLines.BELGENO + "" +
",'" + FormLines.BELGESTR + "'" +
",'" + FormLines.ADSOYAD + "'" +
",'" + FormLines.ADRES + "'" +
",'" + FormLines.TEL + "'" +
",'" + FormLines.TEL2 + "'" +
",'" + FormLines.EMAIL + "'" +
",cast('" + MontajDate + "' as datetime)" +
",cast('" + ARIZADATE + "' as datetime)" +
",'" + FormLines.FIRMA + "'" +
",'" + FormLines.SATICIFIRMA + "'" +
",cast('" + FatDate + "' as datetime)" +
",'" + FormLines.FATURANO + "'" +
",'" + FormLines.GARANTINO + "'" +
",'" + FormLines.CIHAZ + "'" +
",'" + FormLines.CIHAZSERINO + "'" +
",'" + GLOBALS.GetCookie("giris")["CLIENTREF"] + "'" +
")";
if (durum == true)
{
int rowsAffected = db.Execute(sqlQuery);
int rowsUpdated = db.Execute("update USERS set BELGEID=BELGEID+1 where LOGICALREF=" + GLOBALS.GetCookie("giris")["USERID"] + "");
int belgeid = Convert.ToInt32(giris["BELGEID"]);
belgeid++;
giris["BELGEID"] = belgeid.ToString();
Response.Cookies.Add(giris);
}
}
// Response.Redirect("FormEdit?ficheno="+ FormLines.BELGESTR + "-" + FormLines.BELGENO+ "&formtype="+Request.QueryString["formtype"]+"");
return(Json(new
{
success = durum
}, JsonRequestBehavior.AllowGet));
// return RedirectToAction("FormEdit",new {ficheno=FormLines.BELGESTR+"-"+FormLines.BELGENO,formtype=Request.QueryString["formtype"] });
}
// GET: Forms/Details/5
public ActionResult Details(int id)
{
LoginCheck();
FORMLines FormDetail = new FORMLines();
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["PTEKNIKMSSQL"].ConnectionString))
{
FormDetail = db.Query <FORMLines>("Select * From FORMLINE where LOGICALREF=" + id, new { id }).SingleOrDefault();
}
return(View(FormDetail));
}
// GET: Forms/Edit/5
public ActionResult FormEdit(string ficheno, string formtype)
{
LoginCheck();
FORMTYPECheck(formtype);
FORMLines FormDetail = new FORMLines();
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["PTEKNIKMSSQL"].ConnectionString))
{
FormDetail = db.Query <FORMLines>("Select * From FORMLINE where FICHENO='" + ficheno + "'").SingleOrDefault();
}
return(View(FormDetail));
}
public ActionResult FormBas(string ficheno, string formtype)
{
FORMLines _DefaultModel = new FORMLines();
using (db)
{
_DefaultModel = db.Query <FORMLines>("select * from FORMLINE where FICHENO='" + ficheno + "'").SingleOrDefault();
}
ViewData["MONTAJDATE"] = (formtype != "MONTAJ") ? "display:none;" : "";
ViewData["ARIZADATE"] = (formtype != "ARIZA") ? "display:none;" : "";
return(View(_DefaultModel));
}
// GET: Forms/Edit/5
public ActionResult TeknikTalepEdit(int id, string formtype)
{
if (!GLOBALS.CookieAuth())
{
return(RedirectToAction("Index", "Home"));
}
FORMTYPECheck(formtype);
FORMLines FormDetail = new FORMLines();
using (db)
{
FormDetail = db.Query <FORMLines>("Select * From FORMLINE where LOGICALREF=" + id, new { id }).SingleOrDefault();
}
return(View(FormDetail));
}
public ActionResult TeknikTalep(string clientid, string caridef, string carikod)
{
if (!GLOBALS.CookieAuth())
{
return(RedirectToAction("Index", "Home"));
}
FORMLines _fORMLines = new FORMLines();
_fORMLines.BELGENO = Convert.ToInt32(cookie["BELGEID"]);
_fORMLines.BELGESTR = cookie["USERID"];
_fORMLines.CLIENTREF = Convert.ToInt32((clientid == null)?"0":clientid);
_fORMLines.NAME = caridef;
_fORMLines.CODE = carikod;
return(View(_fORMLines));
}
public ActionResult TeknikTalepEdit(int id, FORMLines FormLines)
{
if (!GLOBALS.CookieAuth())
{
return(RedirectToAction("Index", "Home"));
}
using (db)
{
string sqlQuery = "update [dbo].[FORMLINE] set " +
"BELGENO=" + FormLines.BELGENO + "" +
",BELGESTR='" + FormLines.BELGESTR + "'" +
",ADSOYAD='" + FormLines.ADSOYAD + "'" +
",ADRES='" + FormLines.ADRES + "'" +
",TEL='" + FormLines.TEL + "'" +
" WHERE LOGICALREF=" + id;
int rowsAffected = db.Execute(sqlQuery);
}
return(RedirectToAction("TeknikTalepler"));
}
public ActionResult FormBas(string ficheno)
{
FORMLines _DefaultModel = new FORMLines();
if (ficheno != "0")
{
using (db)
{
_DefaultModel = db.Query <FORMLines>("select * from FORMLINE where FICHENO='" + ficheno + "'").SingleOrDefault();
}
}
else
{
_DefaultModel.BELGENO = Convert.ToInt32(GLOBALS.GetCookie("fichenos")["BELGEID"]);
_DefaultModel.BELGESTR = GLOBALS.GetCookie("fichenos")["CLIENTREF"];
_DefaultModel.FORMTYPE = "MONTAJ";
_DefaultModel.MONTAJDATE = DateTime.Now;
}
return(View(_DefaultModel));
}
public ActionResult TeknikTalep(FORMLines _talep)
{
if (!GLOBALS.CookieAuth())
{
return(RedirectToAction("Index", "Home"));
}
using (db)
{
string sqlQuery = "INSERT INTO [dbo].[FORMLINE](ISTALEP,FICHENO,ACIKLAMA,CLIENTREF,NAME,CODE,FORMTYPE,ADMIN,DURUM,BELGESTR,BELGENO,ADSOYAD,FIRMA,ADRES,TEL,ADDDATE) VALUES" +
"(1,'" + _talep.BELGESTR + "-" + _talep.BELGENO + "','" + _talep.ACIKLAMA + "'," + _talep.CLIENTREF + ",'" + _talep.NAME + "','" + _talep.CODE + "','" + _talep.FORMTYPE + "'," + giris["USERID"] + ",0,'" + _talep.BELGESTR + "'," + _talep.BELGENO + ",'" + _talep.ADSOYAD + "','" + _talep.FIRMA + "','" + _talep.ADRES + "','" + _talep.TEL + "','" + DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss") + "') ";
int rowsAffected = GLOBALS.db.Execute(sqlQuery);
GLOBALS.db.Execute("update USERS set BELGEID=BELGEID+1 where LOGICALREF=" + giris["USERID"] + "");
int belgeid = Convert.ToInt32(cookie["BELGEID"]);
belgeid++;
cookie["BELGEID"] = belgeid.ToString();
Response.Cookies.Add(cookie);
//mail at
}
return(RedirectToAction("TeknikTalepler", "Admin"));
}
public ActionResult FormBas(string ficheno, FORMLines FormLines)
{
bool durum = false;
LoginCheck();
//zorunlu alan kontrolü
if (String.IsNullOrEmpty(FormLines.TEL) && String.IsNullOrEmpty(FormLines.TEL2))
{
TempData["msg"] = "<script>alert('En Az Bir Telefon Numarası Girmelisiniz!!!');</script>";
return(View());
}
if (String.IsNullOrEmpty(FormLines.ADRES) && String.IsNullOrEmpty(FormLines.ADSOYAD))
{
TempData["msg"] = "<script>alert('Müşteri Adı Ve Adres Girmeden İlerleyemezsiniz!!!');</script>";
return(View());
}
if ((FormLines.FORMTYPE == "MONTAJ" && FormLines.MONTAJDATE > DateTime.Now))
{
durum = false;
TempData["msg"] = "<script>alert('İleri Bir Tarih Seçimi Yapamazsınız!!!');</script>";
return(View());
}
string MontajDate = Convert.ToDateTime(((FormLines.MONTAJDATE == null) ? DateTime.Parse("1900-01-01") : FormLines.MONTAJDATE)).ToString("MM/dd/yyyy");
if (ficheno != "0")
{
string sqlQuery = "update [dbo].[FORMLINE] set " +
"ADSOYAD='" + FormLines.ADSOYAD + "'" +
",ADRES='" + FormLines.ADRES + "'" +
",TEL='" + FormLines.TEL + "'" +
",TEL2='" + FormLines.TEL2 + "'" +
",EMAIL='" + FormLines.EMAIL + "'" +
",MONTAJDATE='" + MontajDate + "'" +
",FIRMA='" + FormLines.FIRMA + "'" +
",SATICIFIRMA='" + FormLines.SATICIFIRMA + "'" +
",FATURANO='" + FormLines.FATURANO + "'" +
",GARANTINO='" + FormLines.GARANTINO + "'" +
",CIHAZ='" + FormLines.CIHAZ + "'" +
",CIHAZSERINO='" + FormLines.CIHAZSERINO + "'" +
",CACIKLAMA='" + FormLines.CACIKLAMA + "'" +
" WHERE FICHENO='" + ficheno + "'";
int rowsAffected = db.Execute(sqlQuery);
return(RedirectToAction("FormLine", new { ficheno = ficheno, adsoyad = FormLines.ADSOYAD }));
}
FormLines.BELGENO = Convert.ToInt32(GLOBALS.GetCookie("fichenos")["BELGEID"]);
FormLines.BELGESTR = GLOBALS.GetCookie("fichenos")["CLIENTREF"];
using (db)
{
string sqlQuery = "INSERT INTO [dbo].[FORMLINE](ADDDATE,NAME,FORMTYPE,FICHENO,[BELGENO],[BELGESTR],[ADSOYAD],[ADRES],[TEL],[TEL2],[EMAIL],[MONTAJDATE],[FIRMA],[SATICIFIRMA],ACIKLAMA,CLIENTREF)VALUES" +
"(GETDATE(),(select DEFINITION_ FROM LKSDB..LG_" + GLOBALS.GFirma + "_CLCARD WHERE LOGICALREF=" + GLOBALS.GetCookie("giris")["CLIENTREF"] + "),"
+ "'" + FormLines.FORMTYPE + "','" + FormLines.BELGESTR + "-" + FormLines.BELGENO + "'," + FormLines.BELGENO + "" +
",'" + FormLines.BELGESTR + "'" +
",'" + FormLines.ADSOYAD + "'" +
",'" + FormLines.ADRES + "'" +
",'" + FormLines.TEL + "'" +
",'" + FormLines.TEL2 + "'" +
",'" + FormLines.EMAIL + "'" +
",cast('" + MontajDate + "' as datetime)" +
",'" + FormLines.FIRMA + "'" +
",'" + FormLines.SATICIFIRMA + "'" +
",'" + FormLines.ACIKLAMA + "'" +
",'" + GLOBALS.GetCookie("giris")["CLIENTREF"] + "'" +
")";
int rowsAffected = db.Execute(sqlQuery);
int rowsUpdated = db.Execute("update USERS set BELGEID=BELGEID+1 where LOGICALREF=" + GLOBALS.GetCookie("giris")["USERID"] + "");
int belgeid = Convert.ToInt32(cookie["BELGEID"]);
belgeid++;
cookie["BELGEID"] = belgeid.ToString();
cookie.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(cookie);
}
return(RedirectToAction("FormLine", new { ficheno = FormLines.BELGESTR + "-" + FormLines.BELGENO, adsoyad = FormLines.ADSOYAD }));
}
