Example #1
0
        public JsonResult GetBinderAlotDtlByAllotCode(string binderAllotCode, string date)
        {
            int    status = default(int);
            string msg    = string.Empty;

            try
            {
                DataTable dt = objDbTrx.GetBinderAlotDtlByAllotCode(binderAllotCode);
                if (dt.Rows.Count > default(int))
                {
                    int challanId = default(int);
                    int.TryParse(dt.Rows[0]["CHALLAN_ID"].ToString(), out challanId);

                    if (challanId == default(int))
                    {
                        msg    = string.Format("{0}^{1}^{2}", dt.Rows[0]["COMMON_BOOK_CODE"].ToString(), dt.Rows[0]["LOT"].ToString(), dt.Rows[0]["DTLID"].ToString());
                        status = 1;
                    }
                    else
                    {
                        status = 5;
                        msg    = "Already Exist";
                    }
                }
                else
                {
                    //return Json(new { Success = 5, Message = "Already Exist" });
                    status = 2;
                }
            }
            catch (Exception ex)
            {
                objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
                status = default(int);
                msg    = ex.Message;
            }
            return(Json(new { Success = status, Message = msg }));
        }