public object UpdateHcEmergencycontactInfo(object param)
{
Database db = DatabaseFactory.CreateDatabase();
object retObj = null;
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
HcEmergencycontactEntity hcEmergencycontactEntity = (HcEmergencycontactEntity)param;
HcEmergencycontactDAL hcEmergencycontactDAL = new HcEmergencycontactDAL();
retObj = (object)hcEmergencycontactDAL.UpdateHcEmergencycontactInfo(hcEmergencycontactEntity, db, transaction);
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
finally
{
connection.Close();
}
}
return(retObj);
}
public DataTable GetAllHcEmergencycontactRecord(object param)
{
Database db = DatabaseFactory.CreateDatabase();
string sql = @"
SELECT A.ID, A.UserId, B.Address, A.userphone, B.postalcode, A.emergencyContactPerson, A.emergencycontactPhone, A.createdBy, A.createdAt, A.updateBy, A.upadateAt FROM HC_EmergencyContact A, [HC_Users] B
where 1=1
and A.UserId = B.ID";
HcEmergencycontactEntity iGet = new HcEmergencycontactEntity();
if (param != null)
{
iGet = (HcEmergencycontactEntity)param;
}
if (!string.IsNullOrEmpty(iGet.Userid))
{
sql += " AND A.UserId = '" + iGet.Userid + "' ";
}
DbCommand dbCommand = db.GetSqlStringCommand(sql);
DataSet ds = db.ExecuteDataSet(dbCommand);
return(ds.Tables[0]);
}
public HcEmergencycontactEntity GetSingleHcEmergencycontactRecordById(object param)
{
Database db = DatabaseFactory.CreateDatabase();
string sql = "SELECT ID, UserId, emergencyContactPerson, emergencycontactPhone, createdBy, createdAt, updateBy, upadateAt FROM HC_EmergencyContact WHERE Id=@Id";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Id", DbType.String, param);
HcEmergencycontactEntity hcEmergencycontactEntity = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
hcEmergencycontactEntity = new HcEmergencycontactEntity();
if (dataReader["ID"] != DBNull.Value)
{
hcEmergencycontactEntity.Id = dataReader["ID"].ToString();
}
if (dataReader["UserId"] != DBNull.Value)
{
hcEmergencycontactEntity.Userid = dataReader["UserId"].ToString();
}
if (dataReader["emergencyContactPerson"] != DBNull.Value)
{
hcEmergencycontactEntity.Emergencycontactperson = dataReader["emergencyContactPerson"].ToString();
}
if (dataReader["emergencycontactPhone"] != DBNull.Value)
{
hcEmergencycontactEntity.Emergencycontactphone = dataReader["emergencycontactPhone"].ToString();
}
if (dataReader["createdBy"] != DBNull.Value)
{
hcEmergencycontactEntity.Createdby = dataReader["createdBy"].ToString();
}
if (dataReader["createdAt"] != DBNull.Value)
{
hcEmergencycontactEntity.Createdat = dataReader["createdAt"].ToString();
}
if (dataReader["updateBy"] != DBNull.Value)
{
hcEmergencycontactEntity.Updateby = dataReader["updateBy"].ToString();
}
if (dataReader["upadateAt"] != DBNull.Value)
{
hcEmergencycontactEntity.Upadateat = dataReader["upadateAt"].ToString();
}
}
}
return(hcEmergencycontactEntity);
}
public bool UpdateHcEmergencycontactInfo(HcEmergencycontactEntity hcEmergencycontactEntity, Database db, DbTransaction transaction)
{
string sql = "UPDATE HC_EmergencyContact SET UserId= @Userid, emergencyContactPerson= @Emergencycontactperson, emergencycontactPhone= @Emergencycontactphone, createdBy= @Createdby, createdAt= @Createdat, updateBy= @Updateby, upadateAt= @Upadateat WHERE Id=@Id";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Id", DbType.String, hcEmergencycontactEntity.Id);
db.AddInParameter(dbCommand, "Userid", DbType.String, hcEmergencycontactEntity.Userid);
db.AddInParameter(dbCommand, "Emergencycontactperson", DbType.String, hcEmergencycontactEntity.Emergencycontactperson);
db.AddInParameter(dbCommand, "Emergencycontactphone", DbType.String, hcEmergencycontactEntity.Emergencycontactphone);
db.AddInParameter(dbCommand, "Createdby", DbType.String, hcEmergencycontactEntity.Createdby);
db.AddInParameter(dbCommand, "Createdat", DbType.String, hcEmergencycontactEntity.Createdat);
db.AddInParameter(dbCommand, "Updateby", DbType.String, hcEmergencycontactEntity.Updateby);
db.AddInParameter(dbCommand, "Upadateat", DbType.String, hcEmergencycontactEntity.Upadateat);
db.ExecuteNonQuery(dbCommand, transaction);
return(true);
}
public object SaveHcEmergencycontactInfo(HcEmergencycontactEntity hcEmergencycontactEntity, Database db, DbTransaction transaction)
{
string sql = @"INSERT INTO HC_EmergencyContact ( UserId, UserPhone,emergencyContactPerson, emergencycontactPhone, createdBy, createdAt, updateBy, upadateAt) output inserted.ID VALUES ( @Userid, @Userphone, @Emergencycontactperson, @Emergencycontactphone, @Createdby, @Createdat, @Updateby, @Upadateat )";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Userid", DbType.String, hcEmergencycontactEntity.Userid);
db.AddInParameter(dbCommand, "Userphone", DbType.String, hcEmergencycontactEntity.Userphone);
db.AddInParameter(dbCommand, "Emergencycontactperson", DbType.String, hcEmergencycontactEntity.Emergencycontactperson);
db.AddInParameter(dbCommand, "Emergencycontactphone", DbType.String, hcEmergencycontactEntity.Emergencycontactphone);
db.AddInParameter(dbCommand, "Createdby", DbType.String, hcEmergencycontactEntity.Createdby);
db.AddInParameter(dbCommand, "Createdat", DbType.String, hcEmergencycontactEntity.Createdat);
db.AddInParameter(dbCommand, "Updateby", DbType.String, hcEmergencycontactEntity.Updateby);
db.AddInParameter(dbCommand, "Upadateat", DbType.String, hcEmergencycontactEntity.Upadateat);
//db.ExecuteNonQuery(dbCommand, transaction);
//return true;
var id = db.ExecuteScalar(dbCommand, transaction).ToString();
return(id);
}
public bool DeleteHcEmergencycontactInfoById(object param, Database db, DbTransaction transaction)
{
string sql = @"DELETE FROM HC_EmergencyContact";
HcEmergencycontactEntity iGet = new HcEmergencycontactEntity();
if (param != null)
{
iGet = (HcEmergencycontactEntity)param;
}
if (!string.IsNullOrEmpty(iGet.Userid))
{
sql += " WHERE UserId = '" + iGet.Userid + "' ";
}
DbCommand dbCommand = db.GetSqlStringCommand(sql);
// db.AddInParameter(dbCommand, "UserId", DbType.String, param);
db.ExecuteNonQuery(dbCommand, transaction);
return(true);
}