public ActionResult GetCardInfo(string cardno)
{
try
{
if (!String.IsNullOrEmpty(cardno))
{
OraDBCardInfo.OradbaccessSoap client=new OradbaccessSoapClient();
DataTable details = client.GetCCardDetail(cardno);
string clientName = "";
if (details != null)
{
foreach (DataRow row in details.Rows)
{
clientName = (string) row[2];
return Json(clientName, JsonRequestBehavior.AllowGet);
}
Json(null, JsonRequestBehavior.AllowGet);
}
//return Json(null, JsonRequestBehavior.AllowGet);
}
return Json(null, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
return Json("error",JsonRequestBehavior.DenyGet);
}
}
public ActionResult GetCardInfo(string cardno)
{
try
{
OradbaccessSoap service = new OradbaccessSoapClient();
DataTable dt = service.GetCCardDetail(cardno);
if (dt != null)
{
string userPhoto = "";
string signature = "";
string clientname = "";
string bday = "";
DateTime dob = DateTime.Now;
foreach (DataRow dataRow in dt.Rows)
{
userPhoto = Convert.ToBase64String((byte[])dataRow[4]);
signature = Convert.ToBase64String((byte[])dataRow[5]);
clientname = (string)dataRow[2];
dob = (DateTime)dataRow[3];
bday = dob.ToString("dd-MMM-yyyy");
}
var model = new { Bday = bday, cardno, userPhoto, signature, name = clientname };
return(Json(model, JsonRequestBehavior.AllowGet));
}
return(Json(null));
}
catch (Exception)
{
return(Json("Error", JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetCardInfo(string cardno)
{
try
{
OradbaccessSoap service = new OradbaccessSoapClient();
DataTable dt = service.GetCCardDetail(cardno);
if (dt != null)
{
string userPhoto = "";
string signature = "";
string clientname = "";
string bday = "";
DateTime dob = DateTime.Now;
foreach (DataRow dataRow in dt.Rows)
{
userPhoto = Convert.ToBase64String((byte[])dataRow[4]);
signature = Convert.ToBase64String((byte[])dataRow[5]);
clientname = (string)dataRow[2];
dob = (DateTime)dataRow[3];
bday = dob.ToString("dd-MMM-yyyy");
}
var model = new { Bday=bday, cardno, userPhoto, signature, name = clientname };
return Json(model,JsonRequestBehavior.AllowGet);
}
return Json(null);
}
catch (Exception)
{
return Json("Error", JsonRequestBehavior.AllowGet);
}
}
public ActionResult GetCardInfo(string cardno)
{
try
{
if (!String.IsNullOrEmpty(cardno))
{
OraDBCardInfo.OradbaccessSoap client = new OradbaccessSoapClient();
DataTable details = client.GetCCardDetail(cardno);
string clientName = "";
if (details != null)
{
foreach (DataRow row in details.Rows)
{
clientName = (string)row[2];
return(Json(clientName, JsonRequestBehavior.AllowGet));
}
Json(null, JsonRequestBehavior.AllowGet);
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json("error", JsonRequestBehavior.DenyGet));
}
}
public ActionResult GetInfo(string leafno)
{
try
{
var leafstatus = db.CARDCHLEAF.Where(x => x.LEAFNO == leafno).Select(x => x.LEAFSTATUS).FirstOrDefault();
if (leafstatus == 10)
{
var chequeId = db.CARDCHLEAF.Where(x => x.LEAFNO == leafno).Select(x => x.CHEQUEID).FirstOrDefault();
var leafID = db.CARDCHLEAF.Where(x => x.LEAFNO == leafno).Select(x => x.ID).FirstOrDefault();
var cardno = db.CARDCHEREUISITION.Where(x => x.ID == chequeId).Select(x => x.CARDNO).FirstOrDefault();
OradbaccessSoap service = new OradbaccessSoapClient();
DataTable dt = service.GetCCardDetail(cardno);
if (dt != null)
{
string userPhoto = "";
string signature = "";
string clientname = "";
foreach (DataRow dataRow in dt.Rows)
{
// var signatureByte = (byte[]) dataRow[5];
// var userPhotoByte = (byte[]) dataRow[4];
if (dataRow[5] != null)
{
signature = Convert.ToBase64String((byte[])dataRow[5]);
}
if (dataRow[4] != null)
{
userPhoto = Convert.ToBase64String((byte[])dataRow[4]);
}
clientname = (string)dataRow[2];
}
var model = new { leafID, cardno, userPhoto, signature, name = clientname };
return(Json(model));
}
return(Json(null));
}
else if (leafstatus == 11)
{
return(Json("used"));
}
return(Json("invalid"));
}
catch (Exception exception)
{
return(Json("invalid"));
}
}
public ActionResult GetInfo(string leafno)
{
try
{
var leafstatus = db.CARDCHLEAF.Where(x => x.LEAFNO == leafno).Select(x => x.LEAFSTATUS).FirstOrDefault();
if (leafstatus == 10)
{
var chequeId = db.CARDCHLEAF.Where(x => x.LEAFNO == leafno).Select(x => x.CHEQUEID).FirstOrDefault();
var leafID = db.CARDCHLEAF.Where(x => x.LEAFNO == leafno).Select(x => x.ID).FirstOrDefault();
var cardno = db.CARDCHEREUISITION.Where(x => x.ID == chequeId).Select(x => x.CARDNO).FirstOrDefault();
OradbaccessSoap service = new OradbaccessSoapClient();
DataTable dt = service.GetCCardDetail(cardno);
if (dt != null)
{
string userPhoto="";
string signature="";
string clientname = "";
foreach (DataRow dataRow in dt.Rows)
{
// var signatureByte = (byte[]) dataRow[5];
// var userPhotoByte = (byte[]) dataRow[4];
if (dataRow[5] != null)
{
signature = Convert.ToBase64String((byte[])dataRow[5]);
}
if (dataRow[4] != null)
{
userPhoto = Convert.ToBase64String((byte[])dataRow[4]);
}
clientname = (string)dataRow[2];
}
var model = new { leafID, cardno, userPhoto, signature, name = clientname };
return Json(model);
}
return Json(null);
}
else if (leafstatus == 11)
{
return Json("used");
}
return Json("invalid");
}
catch (Exception exception)
{
return Json("invalid");
}
}
