public static VW_USER isUserAuthetic(string name, string pwd)
{
VW_USER uObj = new VW_USER();
MMR_CP22Entities1 _context = new MMR_CP22Entities1();
var pe = _context.VW_USER.Where(s => s.uName == name &&
s.uPassword == pwd
).ToList();
if (pe.Count > 0)
{
uObj = pe.First();
uObj.uPassword = "******";
}
return(uObj);
}
public static string CreatePreEnter(string bmonth, string SDivCode, string CcCode, VW_USER user)
{
string status = "UnKnown";
try
{
string conStr = System.Configuration.ConfigurationManager.ConnectionStrings["hesco"].ToString();
DBUtil dbUtil = new DBUtil(conStr);
DataTable dt = dbUtil.GetCP22MasterData(bmonth, SDivCode, CcCode);
var _context = new MMR_CP22Entities1();
if (dt != null && dt.Rows.Count > 0)
{
int recNO = 0;
foreach (DataRow dr in dt.Rows)
{
try
{
/*
* Insert Into Cp22_Formb("MONTH", Bmonth, Feeder, Feeder_Name, Mfactor, Prev_Read, PREV_KVARH_READ, Meter_Range, Sdiv_1, Share_1, Fdrsdiv, Fdrcircle, Proof_Listing_Flag, Posted_Flag, Divcode, U_Name, Cp_No, Cc_Code, Record_No, Created_On, Created_By,Type,Main_Feeder,METER_NO,STATUS_CODE)
* Values(Vmonth, P_Month, Vfdrcode, Vfdrname, Vmfactor, Vprev_Reading, vPREV_KVARH_READING_A, Vmeter_Range, Vfdrsdiv , '100.00', Vfdrsdiv, Vcircle, 'N', 'N', Vdivcode, Vu_Name, Vcp_No, Vcc_Code, Vrecord_No, Systimestamp, 'PREENTER',Vtype,Vmain_Feeder,vMTR_NO,'P');
*/
CP22_FORMB formB = new CP22_FORMB();
formB.MONTH = dr["Vmonth"].ToString();
formB.BMONTH = DateTime.ParseExact(dr["vPMonth"].ToString(), "MMyyyy", System.Globalization.CultureInfo.InvariantCulture);
formB.FEEDER = dr["Vfdrcode"].ToString();
formB.FEEDER_NAME = dr["Vfdrname"].ToString();
formB.MFACTOR = decimal.Parse(dr["Vmfactor"].ToString());
formB.PREV_READ = decimal.Parse(dr["Vprev_Reading"].ToString());
formB.PREV_KVARH_READ = !string.IsNullOrEmpty(dr["vPREV_KVARH_READING_A"].ToString()) ? decimal.Parse(dr["vPREV_KVARH_READING_A"].ToString()) : 0;
formB.METER_RANGE = !string.IsNullOrEmpty(dr["vMTR_RANGE"].ToString()) ? byte.Parse(dr["vMTR_RANGE"].ToString()) : new byte();
formB.SDIV_1 = dr["Vfdrsdiv"].ToString();
formB.SHARE_1 = 100;
formB.FDRSDIV = dr["Vfdrsdiv"].ToString();
formB.FDRCIRCLE = dr["Vcircle"].ToString();
formB.PROOF_LISTING_FLAG = "N";
formB.POSTED_FLAG = "N";
formB.DIVCODE = SDivCode;
formB.U_NAME = user.uName;
formB.CP_NO = "CP22";
formB.CC_CODE = CcCode;
formB.RECORD_NO = recNO + 1;
formB.CREATED_ON = DateTime.Now;
formB.CREATED_BY = "PREENTER-MMR";
formB.TYPE = dr["Vtype"].ToString();
formB.MAIN_FEEDER = dr["vMAIN_FEEDER"].ToString();
formB.METER_NO = dr["vMTR_NO"].ToString();
formB.STATUS_CODE = "P";
formB.GRID_CODE = user.GRID_CODE;
formB.GRID_NAME = user.GRID_NAME;
_context.CP22_FORMB.Add(formB);
recNO++;
}
catch (Exception ex)
{
}
}
_context.SaveChanges();
status = recNO.ToString() + " / " + dt.Rows.Count.ToString() + " created successfully";
}
else
{
status = "No data found for given criteria!";
}
}
catch (DbEntityValidationException e)
{
StringBuilder sb = new StringBuilder();
foreach (var eve in e.EntityValidationErrors)
{
sb.AppendFormat("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
sb.AppendFormat("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage);
}
}
status = sb.ToString();
}
catch (Exception ex)
{
status = ex.ToString();
}
return(status);
}
