public ENT.DMT_MoneyRemittance GetById(Guid guid)
{
ENT.DMT_MoneyRemittance Entity = new ENT.DMT_MoneyRemittance();
try
{
parFields.Clear();
//Add Query in to string builder object
QueryDisctionery.SelectPart = "select DMT_MoneyRemittance.* ,(DMT_CustomerRegister.dmt_firstname + ' ' + DMT_CustomerRegister.dmt_lastname) as customername";
QueryDisctionery.TablePart = @"from DMT_MoneyRemittance
inner join DMT_CustomerRegister on DMT_MoneyRemittance.mt_RemitterId = DMT_CustomerRegister.dmt_requestno";
//Execute Query and get SQLDataReader
using (SqlDataReader dr = objDBHelper.ExecuteReaderQuery(QueryDisctionery, parFields, objEntity))
{
Entity = COM.DBHelper.CopyDataReaderToSingleEntity <ENT.DMT_MoneyRemittance>(dr);
objDBHelper.Disposed();
}
}
catch (Exception)
{
throw;
}
finally
{
parFields.Clear();
}
return(Entity);
}
public COM.MEMBERS.SQLReturnMessageNValue DMT_REMITTANCE(ENT.DMT_MoneyRemittance obj)
{
try
{
string[,] param =
{
{ "USERID", obj.userid.ToString() },
{ "BENEFICIARYCODE", obj.mt_beneficiarycode.ToString() },
{ "BENEFICIARYMOBILE", obj.mt_BeneficiryMobile.ToString() },
{ "CUSTOMERMOBILE", obj.mt_customermobile.ToString() },
{ "IFSCCODE", obj.mt_ifsc.ToString() },
{ "ACOOUNTNO", obj.mt_accountnumber.ToString() },
{ "ROUTINGTYPE", obj.mt_routingtype.ToString() },
{ "BENEFICIARYNAME", obj.mt_BeneficiaryName.ToString() },
{ "REMARKS", obj.mt_remarks.ToString() },
{ "AMOUNT", obj.mt_amount.ToString() },
{ "TRANSACTIONMODE", obj.mt_mode.ToString() },
{ "RemitterId", obj.mt_RemitterId.ToString() },
{ "IpAddress", obj.mt_Ipaddress.ToString() },
{ "RequestNo", obj.mt_RequestNo.ToString() },
{ "Response", obj.mt_Response.ToString() }
};
COM.MEMBERS.SQLReturnMessageNValue Mval = SqlHelper.ExecuteProcedureReturnMessageNValue("DMT_REMITTANCE", param);
return(Mval);
}
catch (Exception ex)
{
throw ex;
}
}
public object GetByPrimaryKey(ENT.DMT_MoneyRemittance Entity)
{
object objResult = null;
try
{
DAL.CRUDOperation tt = new DAL.CRUDOperation();
objResult = tt.GetEntityByPrimartKey(Entity);
}
catch (Exception)
{
throw;
}
return(objResult);
}
// this function for just referance for partial update field user have to create seperate function learn from this function.
public bool UpdatePartial(ENT.DMT_MoneyRemittance objEntity)
{
bool blnResult = false;
try
{
//Create Fields List in dictionary
Dictionary <string, bool> dctFields = new Dictionary <string, bool>();
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.mt_id), true);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.userid), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.mt_customermobile), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.mt_BeneficiryMobile), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.mt_accountnumber), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.mt_ifsc), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.mt_beneficiarycode), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.mt_amount), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.mt_routingtype), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.mt_BeneficiaryName), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.mt_remarks), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.mt_mode), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.mt_entrydate), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.mt_charge), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.mt_beforebal), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.mt_balance), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.mt_totalamount), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.mt_Ipaddress), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.mt_RequestNo), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.mt_Response), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.mt_RemitterId), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.Status), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.SystemDateTime), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.CreatedBy), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.CreatedDateTime), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.UpdatedBy), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_MoneyRemittance>(x => x.UpdatedDateTime), false);
objEntity.FieldCollection = dctFields;
if (objDAL.SaveChanges(objEntity.FieldCollection, objEntity))
{
blnResult = true;
}
}
catch (Exception)
{
throw;
}
return(blnResult);
}
public ENT.DMT_MoneyRemittance GetById(Guid guid)
{
ENT.DMT_MoneyRemittance Entity = new ENT.DMT_MoneyRemittance();
Entity = clsDAL.GetById(guid);
return(Entity);
}
